Approach and retract macro is disabled. hypermill

#Approach and retract macro is disabled. hypermill code#

Of course, you will have to enable macros, if you want to see the hidden sheets СЂСџв„ўвЂљ There is a major limitation you should be aware of! You can download the sample workbook, to see how it works: Download Sample Workbook: Hide Sheets if Macros are not Enabled.xlsm Sheets('Attention').Visible = xlSheetHidden If Wsh.Name 'Attention' Then Wsh.Visible = xlSheetVisible

#Approach and retract macro is disabled. hypermill code#

Hidden sheets will be unhidden only when users click on the РІР‚СљView WorksheetsРІР‚Сњ button, the code is also simple: Private Sub CommandButton1_Click() If Wsh.Name 'Attention' Then Wsh.Visible = xlSheetVeryHiddenР”Р„pplication.Goto Reference:=Sheets('Attention').Cells(1, 'A') Sheets('Attention').Visible = xlSheetVisible Private Sub Workbook_BeforeClose(Cancel As Boolean) When the workbook is closed, we have to hide the worksheets again, this way the sheets that must remain hidden will be hidden at startup if we do not hide sheets at Workbook_BeforeClose event, hidden sheets will be seen on opening, which is not desired: Option Explicit

Using the Workbook_Open event, if the macros are NOT enabled, the User Form where users can choose to view hidden sheets will not be displayed: Private Sub Workbook_Open()Р”Р„pplication.Goto Reference:=Sheets('Attention').Cells(1, 'AW') And here are the VBA codes, located in ThisWorkbook module.