Really hide an Excel worksheet


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. Brian Veara suggests a better method for Excel 97 or later: press <Alt>-<F11>; in the Project window, double-click Microsoft Excel Objects and select the sheet to hide. Press <F4> and set the Visible property to xlSheetVeryHidden. To unhide the sheet, set the Visible property to xlSheetVisible.

-John Walkenbach


Category: spreadsheet
Issue: June 1999

These Web pages are produced by Australian PC World © 1999 IDG Communications