To set the visible property to xlVeryHidden on ALL sheets in workbook. : Worksheet Hide « Excel « VBA / Excel / Access / Word






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

To set the visible property to xlVeryHidden on ALL sheets in workbook.

 
Sub xlVeryHidden_All_Sheets()
    On Error Resume Next
    Dim sh As Worksheet
    For Each sh In Worksheets
        sh.Visible = xlVeryHidden
    Next
End Sub








Related examples in the same category

1.To set the visible property to True on ALL sheets in workbook
2.To hide specific worksheet
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