Hiding an Excel worksheet with VBA
To hide from the UI, use Format > Sheet > Hide
To hide programatically, use the Visible
property of the Worksheet
object. If you do it programatically, you can set the sheet as "very hidden", which means it cannot be unhidden through the UI.
ActiveWorkbook.Sheets("Name").Visible = xlSheetVeryHidden ' or xlSheetHidden or xlSheetVisible
You can also set the Visible property through the properties pane for the worksheet in the VBA IDE (ALT+F11).
You can do this programmatically using a VBA macro. You can make the sheet hidden or very hidden:
Sub HideSheet() Dim sheet As Worksheet Set sheet = ActiveSheet ' this hides the sheet but users will be able ' to unhide it using the Excel UI sheet.Visible = xlSheetHidden ' this hides the sheet so that it can only be made visible using VBA sheet.Visible = xlSheetVeryHiddenEnd Sub