To toggle between hidden and visible : Worksheet Hide « Excel « VBA / Excel / Access / Word






To toggle between hidden and visible

 
Sub Toggle_Hidden_Visible()
    Worksheets(2).Visible = Not Worksheets(2).Visible
End Sub

 








Related examples in the same category

1.To set the visible property to True on ALL sheets in workbook
2.To set the visible property to xlVeryHidden on ALL sheets in workbook.
3.To hide specific worksheet
4.To make a specific worksheet very hidden
5.To unhide a specific worksheet
6.Hiding and Unhiding Worksheets
7.Unhiding Every Worksheet in a Workbook.
8.Hides the worksheet