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