I performed a search on "unhide multiple worksheets" and found a few
responses. You can unhide multiple worksheets using a macro.

Gord Dibbon provided the following macro to a user who had the same question:

Sub Show_Sheets()
Dim i As Integer
For i = 1 To ActiveWorkbook.Worksheets.Count
ActiveWorkbook.Worksheets(i).Visible = True
Next i
End Sub


HTH

"Wanna Learn" wrote:

Hi My workbook contains 40 worksheets . I need to unhide 35 of the
worksheets. Is there an easier way to unhide worksheets other than one at a
time?