How do you unhide multiple sheets?

[hrelden3]

I hid a lot of sheets, now I seem tho have to unhide them one by one. Is there a btter way?

 

[Fluff]

Short of using VBA, not that I know of.

 

[hrelden3]

Short of using VBA, not that I know of.

Thanks Fluff, I am going to check that out. My first thread. I saw my new boss use Mr Excel. Thanks again

 

[Fluff]

This will unhide all sheets in the workbook

Sub hrelden3()
    Dim Ws As Worksheet
    For Each Ws In Worksheets
        Ws.Visible = xlSheetVisible
    Next Ws
End Sub