Excel Tips : How to unhide Multiple Sheets in Excel

Steps to Unhide all the sheets in Excel at once.
1. Press Alt+F11 or Developer >> Visual Basic
2. Go to Insert >> Module
3. In the VBA Code Editor Window, copy and paste the following Code.

Sub Unhide_Multiple_Sheets()
Dim ws As Worksheet
 
    For Each ws In ActiveWorkbook.Worksheets
     
        ws.Visible = xlSheetVisible
 
    Next ws

End Sub

4. Then click RUN Button on Standard toolbar
5. And there you will get all hideen sheets unhidden.

Share this Post if Your Like.