LinkedIn facebook


VBA - Hiding Sheets* 27/10/2001

To hide your worksheet from users you can use the following code.

Sub HideSheet()
Sheet1.Visible = xlSheetVeryHidden
End Sub

If you hide your sheets this way, users will not be able to unhide them using the menus. Only using VB codes will be able to display the sheets again.