Hide or Unhide All Worksheets Using Macros in Excel
If you are facing trouble while trying to unhide all worksheets in your Excel. Then this tutorial will help you to unhide all worksheets by using the Macros in your Excel.
Before following the procedure of this tutorial make sure you have enabled the Excel’s Developer Tab.
Purpose of this tutorial: UnHide all other worksheets except the active worksheet
PREVIOUSLY:- How to Hide All Worksheets Using Macros in Excel?
Here is a screenshot of a sheet where we have hidden all those sheets;
Now we will unhide all these sheets using simple macros code
STEP 1: GO TO DEVELOPER> CODE> VISUAL BASIC> COPY/PASTE THE CODE BELOW > CLOSE THE WINDOW
Copy The Code Below;
Dim worksheet As Worksheet
‘Loop through all worksheets and set them to visible
For Each worksheet In ActiveWorkbook.Worksheets
worksheet.Visible = xlSheetVisible
STEP 2: Now first you have to open the sheet that contains data with the help of this procedure: Go to Developer > Code > Macros > Run
Here is the result on the unhidden sheet;