Hides the worksheet : Worksheet Hide « Excel « VBA / Excel / Access / Word






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

Hides the worksheet

 
Sub HideWorksheet(ws As Worksheet, bVeryHidden As Boolean)

    If bVeryHidden Then
        ws.Visible = xlSheetVeryHidden
    Else
        ws.Visible = xlSheetHidden
    End If
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.To toggle between hidden and visible
7.Hiding and Unhiding Worksheets
8.Unhiding Every Worksheet in a Workbook.