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" 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 |
All times are GMT +1. The time now is 07:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com