How to detect if sheet is hidden?

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

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)


"hstijnen" <[email protected]> wrote in message
news:[email protected]...
> 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