Microsoft Excel Hints and Tips
Question
How do I hide a worksheet so that it does not appear in the Format >
Sheet > Unhide... Dialog Box ?
Solution
Right click on the worksheet tab that you want to hide and then select
view code. Then press F4 to view the Properties
Dialog Box. There is a property called Visible - change this to
xlSheetVeryHidden. Note that you must have at least one sheet visible
at all times.
Return to Excel Exchange homepage.