Very Hidden

  • Thread starter Thread starter Cliff
  • Start date Start date
C

Cliff

I am searching for any Very Hidden sheet or Macro. Can anyone tell me how to
find out if there is anything in a workbook. I know there is a property you
can set but cannot remember the details.

Much appreciated.
 
A workbook must have at least one visible sheet. Even if the workbook
itself isn't visible, at least one of its sheets must be marked
visible.

To list all xlVeryHidden worksheets, use something like the following:

Sub AAA()
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
If WS.Visible = xlSheetVeryHidden Then
Debug.Print WS.Name & " is xlVeryHidden"
End If
Next WS
End Sub

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top