Hiding Sheets

You can hide sheets to prevent users from displaying them

Sheets("Sheet2").Visible = xlSheetVisibility.xlSheetVeryHidden 
Sheets("Sheet2").Visible = True | False

Using xlSheetVeryHidden will mean the worksheet is not displayed in the (Format > Sheet > Unhide) dialog box.





© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext