» Preventing Hidden Sheets from Appearing
CATEGORY - Excel Security - Protection
VERSION - All Microsoft Excel Versions
When a sheet is hidden and the workbook is not protected, it will still appear in the list of hidden sheets in the Unhide box (from the Format menu, select Sheet, and then Unhide).To prevent hidden sheets from appearing in the Unhide box:
1. Click the Properties icon.
OR
From the Control Toolbox toolbar, click the Properties icon.
2. From the Visible dropdown list, select xlSheetVeryHidden.
To cancel the xlSheetVeryHidden option for a hidden sheet:
1. Press Alt+F11 to open the VBE.
2. Under VBAProject in the left pane, double-click the sheet name you want to unhide.
3. Press F4 or click the Properties icon to open the sheet's Properties dialog box.
4. In the Visible dropdown list, select xlSheetVisible.
5. Press Alt+F4 to close the VBE.
Book Store:
Recommended Books:
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Keys to Reading an Annual Report (Barron's Business Keys)
- Financial Modeling - 2nd Edition
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
No comments have been submitted.
