Want to unhide all worksheets with just a single click? You can unhide all worksheets using Macros in Excel!

Make sure your Excel has the Developer Tab enabled following this tutorial.

I explain how you can do this below step by step!

What does it do?

Unhide all worksheets

Copy Source Code:


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

Final Result: 

Unhide All Worksheets Using Macros In Excel | MyExcelOnline

Exercise Workbook:

Unhide All Worksheets Using Macros In Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK


STEP 1: Go to Developer > Code > Visual Basic

Unhide All Worksheets Using Macros In Excel | MyExcelOnline

 

STEP 2: Paste in your code and Select Save. Close the window afterwards.

Unhide All Worksheets Using Macros In Excel | MyExcelOnline

 

STEP 3: Let us test it out! This is the only tab we are seeing at the moment.

Unhide All Worksheets Using Macros In Excel | MyExcelOnline

Open the sheet containing the data. Go to Developer > Code > Macros

Unhide All Worksheets Using Macros In Excel | MyExcelOnline

 

Make sure your macro is selected. Click Run.

Unhide All Worksheets Using Macros In Excel | MyExcelOnline

 

With just one click, all of the hidden worksheets are now shown!Unhide All Worksheets Using Macros In Excel | MyExcelOnline

 

How to Unhide All Worksheets Using Macros in Excel

 

HELPFUL RESOURCE:

101 Macros Book

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn