» Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
CATEGORY - Excel Customizing , General Topics in VBA
VERSION - All Microsoft Excel Versions
Tip submitted by Kedar Kulkarni, Pune India
To hide a sheet so that no body can unhide it without knowing the password for the Vb Project, simply open the VB Editor and change the visible property to 2 i.e. xlsheetveryhidden.
The sheet should disappear from the Unhide sheets command.
The only way to unhide it is to change the property back to 0 i.e. xlSheetNormal using the password to the VBProject.
Book Store:
Recommended Books:
- Microsoft Excel VBA Programming for the Absolute Beginner
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Microsoft Windows XP Inside Out
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
