[Excel] Unhide Multiple Worksheet

Posted by cikul | Posted in Windows | Posted on 02-09-2014-05-2008


Excel allows us to hide multiple worksheet in one action, but not for unhide, we must unhide the sheets seperately, and it takes more time to do if we have many sheets that need to open.

The way to unhide all worksheets, we can use macro to do this job, this VBA macro will help you to unhide all worksheets in your excel documents.

To open VBA macro press ALT + F11, after Microsoft Visual Basic Open, press F5 to create new macro,

Sub UnhideSheets()
    Dim workSheet As Worksheet

    For Each workSheet In ActiveWorkbook.Worksheets
        workSheet.Visible = xlSheetVisible
    Next workSheet
End Sub

To execute the macro, press F5

Share and Enjoy

Write a comment