» Preventing Hidden Sheets from Appearing
CATEGORY - Excel Security - Protection
VERSION - All Microsoft Excel Versions
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:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Windows XP All-in-One Desk Reference For Dummies
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Marketing Planning for Services
No comments have been submitted.
