» 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:
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Financial Modeling - 2nd Edition
- Definitive Guide to Excel VBA
- Keys to Reading an Annual Report (Barron's Business Keys)
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
No comments have been submitted.
