Hiding Tabs
 

How do I Hide tabs on the worksheets please?


Thanks in advance

Greg

Hiding Tabs
 

Greg, tools, options, view, uncheck sheet tabs, or format sheet hide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Greg B" wrote in message
...
How do I Hide tabs on the worksheets please?


Thanks in advance

Greg

Hiding Tabs
 

Greg, or to hide the sheet in VBA something like

Sheets("Sheet1").Visible = xlHidden or Sheets("Sheet1").Visible =
xlVeryHidden
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Greg B" wrote in message
...
How do I Hide tabs on the worksheets please?


Thanks in advance

Greg

Hiding Tabs
 

Thank you I never noticed that tab

Thanks

Greg