Microsoft Excel Hints and Tips

How do I hide a worksheet so that it does not appear in the Format > Sheet > Unhide... Dialog Box ?

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.

Back to Questions Index

Return to Excel Exchange homepage.