Unhiding Multiple Sheets 3

No it is not magic, but a simple macro!

The problem with un-hiding multiple sheets

Unhiding Multiple Sheets 1


The unhide box (appears when you select unhide from the right click menu on the sheet tab) does not allow you to select multiple sheet names

Here is a VBA Macro to unhide multiple sheets at once!

Sub Unhideallsheets()
For Each Wrksheet In ActiveWorkbook.Worksheets
Wrksheet.Visible = True
Next Wrksheet
End Sub

All you need to do is to paste this code in the code window and run it whenever you want to unhide multiple sheets

Unhiding Multiple Sheets 2

  1. To access the code window, open Visual Basic Explorer. Use the shortcut ALT+F11
  2. From the Insert drop down in the Menu bar, click on Module
  3. In the empty space, paste the code and close the Visual Basic Explorer

 Now run the code whenever you need it

  1. Use the shortcut Alt  F8 to open the list of Macros
  2. Select the Macro and click on Run
  3. Alternatively you can also link it to shape. Create a shape --> Right Click --> Assign Macro --> Select the Macro --> Done


Topics that I write about...

Download Smart Ebooks on
Excel and Power BI