Custom Buttons to Hide & Show Worksheets in Excel

Add to Favorites
Author: | Edits: don

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

Buttons to Navigate to Other Worksheets (no vba required)

Hide or Unhide Worksheets (msft)


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
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.)

View Course

Similar Content on TeachExcel
Print The Current Worksheet in Excel
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...
Link to Cells on Other Worksheets in Excel
Tutorial: It is very easy to link one cell to another cell in Microsoft Excel. The steps needed are ...
Prevent Errors From Appearing in Excel
Tutorial: How to prevent errors from appearing in formulas in Excel. This is especially helpful for...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Print Only Specific Parts of a Worksheet in Excel
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Copy Data or Formatting to Multiple Worksheets in Excel
Tutorial: Quickly copy all or parts of a single worksheet - data, formatting, or both - to multiple...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
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.)

View Course