Hidden Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way when at a glance we know there are hidden worksheets in a
workbook?

Thanks.

zhj23
 
At a glance.........no.

If the sheets are not "veryhidden" through code you can look for hidden sheets
under Format>Sheet>Unhide.


Gord Dibben MS Excel MVP
 
Yes. Provided you use the default excel sheet names provided by Microsoft.
For example, Sheet1, Sheet2,Sheet3 and so on.

Important: if you customize your Worksheet names by replacing the sheet
name(s) then, only you can ascertain, which sheet names are hidden. There is
no way to know how many sheet names does an Worksheet contain.

To Hide Workshet

1. Select the sheets you want to hide.
2. On the Format menu, point to Sheet, and then click Hide.

To display a hidden sheet

1. On the Format menu, point to Sheet, and then click Unhide.

Note: If sheets are hidden by a Microsoft Visual Basic for Applications
program that assigns the property xlSheetVeryHidden, you cannot use the
Unhide command to display the sheets. If you are using a workbook with Visual
Basic macros and have problems with hidden sheets, contact the owner of the
workbook for more information.

2. In the Unhide sheet box, double-click the name of the hidden sheet you
want to display.


Challa Prabhu
 
Back
Top