How to detect if sheet is hidden?

[hstijnen]

Hi,

I've a workbook with several sheets. Formula's in one sheet point to
other sheets. Is there a way to detect, in a formula, whether the
sheet that is pointed to is hidden or not?

Thanks for help,

Henk

 

[Bob Phillips]

You would need a UDF to tell you, like

Function SheetStatus(name As String)
Select Case Worksheets(name).Visible
Case xlSheetHidden: SheetStatus = "Hidden"
Case xlSheetVeryHidden: SheetStatus = "Very Hidden"
Case Else: SheetStatus = "Visible"
End Select
End Function


--

HTH

RP
(remove nothere from the email address if mailing direct)