Ways to hide a worksheet using VBA

By default, worksheets are visible. Some worksheets however contain data not intended to be seen by the user in which case the worksheets property visibility can be changed.

If you want to easily change the visiblity of the worksheet via the menu:


 Dim ws As Worksheet: Set ws =
 ws.Visible = XlSheetVisibility.xlSheetHidden
Note
At least one worksheet must be visible at all times

If you want to allow the users to make the worksheet visible via the menu:


Dim ws As Worksheet: Set ws =
ws.Visible = XlSheetVisibility.xlSheetVeryHidden

If you want to unhide / make the sheet visible using vba:


Dim ws As Worksheet: Set ws =
ws.Visible = XlSheetVisibility.xlSheetVisible