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.

Is this what you are looking for?
http://www.zdnetasia.com/techguide/o...2057638,00.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Cliff" wrote:

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)




On Thu, 10 Sep 2009 09:02:04 -0700, Cliff
wrote:

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.