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 ► www.excelcampu...
** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM**
www.excelcampu...
--
~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) www.excelcampu... ~
~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: www.excelcampu...
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 www.excelcampu...
**********
-- Related Content --
- How to setup your Personal Macro Workbook: • The Personal Macro Wor...
- Create Custom Ribbon with Macro Buttons: • How to Add Macro Butto...
- Copy or Import VBA Code to a Different Workbook: • How To Import Or Copy ...
- The For Next Loop Explained: www.excelcampu...
- Tab Control Add-in Overview Video: • Organize and Automate ...
- Get Tab Hound and Tab Control Add-ins: www.excelcampu...
#ExcelCampus #MsExcel
Негізгі бет Hide And Unhide Multiple Sheets In Excel: Working with Macros
Пікірлер: 34