To hide specific worksheet : Worksheet Hide « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Worksheet Hide

To hide specific worksheet

 

Sub Hide_WS1()
    Worksheets(2).Visible = Hide  ' you can use Hide or False
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 make a specific worksheet very hidden
4.To unhide a specific worksheet
5.To toggle between hidden and visible
6.Hiding and Unhiding Worksheets
7.Unhiding Every Worksheet in a Workbook.
8.Hides the worksheet