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.
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.
'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
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