Unhide Active workbook sheets with VBA Excel for Mac & Windows

Video

Subscribe to YouTube Channel for Exciting Tips & Tricks On Office Applications

With this VBA code, we can easily unhide all the sheet which are hidden in the active workbook.

You can use the code in Excel for mac & windows

1. Copy the below VBA Code by clicking on the copy box
2. Open Microsoft Visual Basic for Applications window Developer Ribbon Tab > Visual Basic (Shortcut keys as follows for mac & windows)
   1. mac users fn  + ⌥ [option] + F11 
   2. windows users Alt  + F11
3. From the menu bar select Insert > Module and insert new Modules
4. Paste the code into the module.

Note: It is always to take a back-up copy of your original before running the code on the original file.

Sub Unhide_All_Sheets()
  'Made It Easy by ExcelExciting.com
  Dim ws As Worksheet
  
    For Each ws In ActiveWorkbook.Worksheets
        ws.Visible = xlSheetVisible
    Next ws
  
End Sub

Was the information helpful in this blog?

• If yes, hit that share button and show the excitement to the world.
• Subscribe to our free posts.

If no, please let us know what to improve.

Having trouble with any Office Apps. Feel free to ask and answer queries at our forums section.