Excel VBA: Worksheet.Visible

The value of worksheet.visible can be set to a value of the xlSheetVisibility enumeration: xlSheetHidden (=0), xlSheetVeryHidden (=2) or xlSheetVisible (=-1).

With xlSheetHidden, the sheet is «only» hidden and user sees the sheet name when right-clicking on any sheet name in the bottom of Excel.

With xlSheetVeryHidden, the user doesn't see the sheet anymore by clicking there.

To show a sheet again with VBA, the property must be set to xlSheetVisible.

In the GUI, the visibility can be set in the Visual Basic Editor (keyboard shortcut alt+F11) in the properties sheet object (found under Microsoft Excel Objects).