For a Limited Period!
Buy 2 ~ Free 1 pax OR Get 30% off for every pax on our scheduled classesAnalyzing Data with Power BI Microsoft Excel - Power Query (M365, 2021-2010) Microsoft Excel - Power Pivot (M365, 2021-2010) Please This email address is being protected from spambots. You need JavaScript enabled to view it. for more info. |
![]() |
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.