Show TRUE in a cell if sheet is hidden

[nutrastat]

Using a formula the sheet/tab names are displayed in a cell; say D4 . In this way, when we change the name on the tab, it will change the name in the cell, and we reference everything off this cell name.

We now wish to have to the right of the cell name (i.e. D5) a cell that will show either TRUE or FALSE if the sheet is hidden (i.e. if the sheet is hidden then the cell will show TRUE).

What formula can we use to test if a sheet is hidden or not, and, just to complicate the issue it should cope with the ability of this sheet to have a name change, and should use the cell reference D4.

Can anyone help please?

 

[Sal Paradise]

For this sheet:

Excel Workbook
	A	B
1	Name	Hidden?
2	Sheet1	FALSE
3	Sheet2	FALSE
4	Sheet3	TRUE
5	Sheet4	FALSE
6	Sheet5	FALSE
Index

I use this code (in the Worksheet code -- Right Click the worksheet name, and paste this):

Option Explicit

Private Sub Worksheet_Calculate()
    Dim i As Integer
    
    For i = 2 To Range("A1").End(xlDown).Row
        If Worksheets(Cells(i, 1).Value).Visible = True Then
            Cells(i, 2).Value = "FALSE"
        Else
            Cells(i, 2).Value = "TRUE"
        End If
    Next i

End Sub

 

[nutrastat]

I have been away working on another project, and therefore ask you to forgive the delay in THANKING you for your answer. Works perfectly!!