Home > VBAUsefulCodes
Hiding the excel sheets is very easy. Using the visible property we can easily control the visibility of the excel sheets.
Show and Hide Excel Sheets using VBA
Hiding the excel sheets is very easy. Using the visible property we can easily control the visibility of the excel sheets.
' Note:
' Use visible = xlVeryHidden if you dont want user, right click and unhide sheet (Only pragrammatically you can unhide)
' use visible = False if you want user, right click and unhide sheet
Sub show_sheets()
Sheets("Sheet1").Visible = True
End Sub
Sub hide_sheets()
Sheets("Sheet1").Visible = xlVeryHidden
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts