Unhide all sheets 3

[PJFry]

Is there a way to unhide multiple sheets at once?

Thanks
PJ

 

[AnotherHiggins]

As far as I know, you can only do this with code.

I use this often enough that I have it linked to a button on a custom toolbar:

Sub UnhideAllSheets()
For i = 1 To Worksheets.Count + Charts.Count
    Sheets(i).Visible = True
Next i
End Sub

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[PJFry]

That worked perfect. Thanks.