Hello All,
I have some 20 worksheets with custom names in them (not the defaults). But i have managed to sequence them with their index name in VBA module from Sheet1 to Sheet20.
How do i loop through these sheets and check if Worksheet is equal to Sheet Index name (Not the custom name).?
Sub CheckSheetByIndex()
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
If sh <> Sheet1 Then ' Here Sheet1 is the name that appears at the beginning in VBA project, its name is INPUT DATA
sh.Visible = xlSheetVeryHidden
End If
Next sh
End Sub
Bookmarks