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

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

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 Preview Screen Display for The Current or Selected Worksheets in Excel
Macro: This free Excel macro allows you to display the print preview screen or window for the cur...
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...