What is the syntax to hide sheets that users cannot find

Worksheets(“<sheet’s name>”).Visible = xlSheetVeryHidden
‘example
Worksheets(“revenueSummary”).Visible = xlSheetVeryHidden

The user is unable to unhide this sheet. It does not show up anywhere on the Excel window that the user sees. To unhide the sheet, replace xlSheetVeryHidden with true.

Advertisements