Hidden tabs
 

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"CWH" wrote in message
...
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?
--
CWH

It worked a treat.

Many thnaks
--
CWH


"Max" wrote:

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"CWH" wrote in message
...
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?
--
CWH

Glad to hear that !
You're welcome ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"CWH" wrote in message
...
It worked a treat.

Many thnaks
--
CWH