When you want to edit those worksheets (or re-hide them….)
1. ALT + F11
2. Ctrl + R (this will display the Project Explorer is not already visible)
3. F4 (this will display the Properties Window if not already visible)
4. In the Project Explorer, click the worksheet you want to hide or show
5. To hide: In the Properties Window, find the Visible property and set it to 2 – xlSheetVeryHidden
6. To show: In the Properties Window, find the Visible Property and set it to -1 - xlsheetVisible
Test it out J
No comments:
Post a Comment