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;

How to Unhide All Worksheets Using Macros in Excel? 1

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;

Sub UnhideAllWorksheets()

Dim worksheet As Worksheet

‘Loop through all worksheets and set them to visible
For Each worksheet In ActiveWorkbook.Worksheets
worksheet.Visible = xlSheetVisible
Next worksheet

End Sub

Unhide All Worksheets

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

Unhide All Worksheets

Here is the result on the unhidden sheet;

Unhide All Worksheets