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" wrote in message
m...
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
|