how to see vba hided sheet code example
Example: vba sheet hide unhide
' Classic sheets
Worksheets("Sheet1").visible = xlSheetHidden
Worksheets("Sheet1").Visible = xlSheetVisible
' Very Hidden sheets
Worksheets("Sheet1").Visible = xlSheetVeryHidden
Worksheets("Sheet1").Visible = xlSheetVisible