Excel VBA: Worksheet.Visible

A worksheet can be hidden by setting its property .visible to xlSheetHidden or xlSheetVeryHidden. If it is «only» hidden, the user sees the sheet name when right-clicking on any sheet name in the bottom of Excel. If the sheet is «very hidden», 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).