Custom Buttons to Hide & Show Worksheets in Excel
Easily hide/show worksheets using a custom button in a worksheet in Excel.
This tutorial shows you a very simple system that anyone can use. It requires a little vba to achieve this result, but that is fully covered in the video.
The reason you might use this feature of vba/Excel is to do things like hide raw data worksheets, helper worksheets, or any other worksheet that the user does not need to see all the time in order to use the workbook.
Additional Resources
Password Protect Sheets in Excel
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...
Tutorial: It is very easy to link one cell to another cell in Microsoft Excel. The steps needed are ...
Tutorial: Make a scrollable box in a worksheet in Excel that allows you to scroll through a table o...
Tutorial: How to prevent errors from appearing in formulas in Excel. This is especially helpful for...
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)