You can use Excel's Format, Sheet, Hide to hide an entire worksheet. But unless you password-protect the workbook structure, anyone can select Format, Sheet, Unhide to see the hidden sheet.
If you use Excel 97 or later, here's another option:
- Press Alt-F11 to display the Visual Basic Editor
- in the Project window, double-click Microsoft Excel Objects and select the sheet to hide.
- Press F4 to display the Property box
- Set the sheet's Visible property to xlSheetVeryHidden.
To unhide the sheet, repeat these step, but set the Visible property to xlSheetVisible.
Post a Comment