Test for if sheet is HIDDEN
See if this code snippet helps you...
Dim WS As Worksheet
For Each WS In Worksheets
If Not WS.Visible Then
Debug.Print WS.Name & " is hidden."
End If
Next
Rick
Am trying to step through sheets, and if one is hidden, so indicate....
This line don't seem to work
If ActiveSheet.Visible = False Then
"DoThis"
Else
"DoThat"
Endif
Any suggestions please?
Vaya con Dios,
Chuck, CABGx3
|