How to Hide and Unhide Multiple Sheets in Excel with a Macro

Learn how to use a set of macros to automate the process of unhiding and hiding (rehiding) multiple sheets in Excel.

-- LINKS --
DOWNLOAD THE WORKBOOK ► excelcampus.com/vba/unhide-re-hide-multiple-she…

*** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM***
excelcampus.com/join-elevate
--
~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) excelcampus.com/blueprint ~

~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: excelcampus.com/newsletter/

In this video I explain how the macro hides and unhides sheets that have a specific tab color. The macro loops through all sheets and changes the visible property to visible or hidden if the sheet is a certain tab color.

This is great if you have a file that you update periodically and send to other users. You might need to unhide sheets to update data and formulas, then rehide those sheets before distributing the file.

I recommend adding the code module to your Personal Macro Workbook, and creating a custom ribbon with macro buttons. This allows you to run the macros on any open workbook on your computer.

**********
EXCEL FRIENDLY ACCESSORIES WE USE (Affiliate Links When Possible): LOGITECH KEYBOARD
Check out all the tech we use and recommend at excelcampus.com/store
**********

-- Related Content --

- How to setup your Personal Macro Workbook: youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzM…
- Create Custom Ribbon with Macro Buttons: youtu.be/dmdolFcS-fI
- Copy or Import VBA Code to a Different Workbook: youtu.be/ett0WiTfQuI
- The For Next Loop Explained: excelcampus.com/vba/for-each-next-loop/
- Tab Control Add-in Overview Video: youtu.be/hD00CKVco5Q
- Get Tab Hound and Tab Control Add-ins: excelcampus.com/tab-hound/


#ExcelCampus #MsExcel