Hidden tabs

[Guest]

I am using Excell 2003

If I have a file with several tabs hidden is there a way to unhide them all
at once, rather than using Format, Sheet, Unhide for each tab?

 

[Max]

One way ..

Roger Govier gave me this sub a few years ago ..

The following will carry out the unhide
for all sheets within the workbook

Sub ShowSheets()
Dim s As Worksheet
For Each s In ActiveWorkbook.Worksheets
s.Visible = True
Next
End Sub

 

[Guest]

It worked a treat.

Many thnaks
--
CWH

One way ..

Roger Govier gave me this sub a few years ago ..

The following will carry out the unhide
for all sheets within the workbook

Sub ShowSheets()
Dim s As Worksheet
For Each s In ActiveWorkbook.Worksheets
s.Visible = True
Next
End Sub

 

[Max]

Glad to hear that !
You're welcome ..