Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my tabs are hidden and can't make them show | Excel Discussion (Misc queries) | |||
format cell tabs hidden in excel dialog box | Excel Discussion (Misc queries) | |||
3 format cell tabs hidden in excel dialog box | Excel Discussion (Misc queries) | |||
excel macros truncating tabs for hidden columns. | Excel Discussion (Misc queries) | |||
Hidden tabs | Excel Discussion (Misc queries) |