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

Tempy,

Worksheets("TBSheet"").Visible = xlVeryHidden

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

hth,

Doug

"Tempy" wrote in message
...
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 ***

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

Tempy

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

Sheets("TBSheet").Visible = False

"Tempy" wrote:

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

while you're in that sheet go to <format<sheethide

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

--
bill

-----------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...info&userid=82
View this thread: http://www.excelforum.com/showthread.php?threadid=40024

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

"Tempy" wrote in message
...
Hi Doug,
thanks for the code, no i am not a fan why do you ask ?

Tempy

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

Tempy

Manually.....FormatSheetHide

Programmatically.....

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


Gord Dibben Excel MVP

On Mon, 29 Aug 2005 13:52:04 -0700, Tempy wrote:

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

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