Hide one sheet tab

[Tempy]

Hi all, is it possible to hide just one tab in a workbook ?
I have a workbook "Recon.xls" with the sheets "Recon for SAP" and
"TBSheet" and i would like to hide "TBSheet"

Thank you in advance,

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

 

[Doug Glancy]

Tempy,

Worksheets("TBSheet"").Visible = xlVeryHidden

You're not a Van Morrison fan by any chance are you?

hth,

Doug

 

[Tempy]

Hi Doug,
thanks for the code, no i am not a fan why do you ask ?

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

 

[bigwheel]

Sheets("TBSheet").Visible = False

 

[bill k]

while you're in that sheet go to <format><sheet>hide

to unhide .............similar pat

 

[Doug Glancy]

Tempy,

In 1967 Van Morrison released Blowing Your Mind which had a 10 minute ramble
called "T.B.Sheets." For your enjoyment, here's a brief excerpt:

The cool room, Lord is a fool's room.
The cool room, Lord is a fool's room.
And I can almost smell your T.B. sheets
And I can almost smell your T.B. sheets
On your sick bed.

Doug

 

[Gord Dibben]

Tempy

Manually.....Format>Sheet>Hide

Programmatically.....

Sub Hide()
Sheets("TBSheet").Visible = False
End Sub


Gord Dibben Excel MVP

 

[Tempy]

Thanks for all ther replies Gents and sorry for the time delay, as i am
in South Africa.

best regards,

Tempy

*** Sent via Developersdex http://www.developersdex.com ***