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 FormatSheetUnhide.


Gord Dibben MS Excel MVP

On Sun, 8 Jul 2007 18:44:00 -0700, zhj23
wrote:

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

Thanks.

zhj23

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


"zhj23" wrote:

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

Thanks.

zhj23

Hi -

You might find this thread useful:
http://groups.google.com/group/micro...1a6ebf38cade91

It references an add-in by Dave Petersen called 'NavToolbar' which
launches every time you open Excel .... also available via the 'View'
drop-down menu.

//ray