Hidden tabs

C

CWH

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?
 
M

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
 
C

CWH

It worked a treat.

Many thnaks
--
CWH


Max said:
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
Click to expand...
 
Top