Home / Worksheets / Unhide Multiple Worksheets

Unhide Multiple Worksheets

Have you ever received a workbook from that has multiple hidden worksheets. The standard approach within Excel is to right click on the worksheet names and select Unhide. Then you need to select one worksheet at a time to unhide. If there are many worksheets this can take forever.

Step 1

Here is a short macro that will unhide all worksheets in a workbook. Open the workbook with the hidden worksheets and start the Visual Basic Editor (Alt + F11). Right Click in the project explorer window and select Insert > Module. Copy the following code into the new Module and then select Run to unhide the worksheets.

Sub UnhideWorksheets()
'This routine will unhide all worksheets in a Workbook
 
Dim i                   As Integer
 
    For i = 1 To ActiveWorkbook.Sheets.Count
        ActiveWorkbook.Sheets(i).Visible = True
    Next
 
End Sub

This code can be used in many other ways to work on worksheets within a workbook.

If you have a question on this post for the Excel Help Desk team or have something you would like to share on this topic then please leave a comment

About Excel Help Desk