Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 119
Default Can I hide tabs?

I have a form with main information on one "tab" of a TabControl, and
less important information on other tabs.

A user has requested an additional tab with information of even more
limited use. So limited, in fact, only a few people would want to know
it even existed, for the rest it's simply confusing.

So is there a way to hide/show whole tabs, INCLUDING the tab selection
thingy (what you click on to select the tab) itself?

Maury
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Can I hide tabs?

You can hide just the tabs via:
tools|options|view tab|Uncheck Sheet tabs
(in xl2003 menus)

But the sheets are still visible (ctrl-pgup and ctrl-pgdn will loop through
these visible sheets).

Or you could hide the worksheet (and its tab):
Select the sheet to hide
Format|Sheet|Hide

(At least one sheet has to be visible, though.)

Maury Markowitz wrote:

I have a form with main information on one "tab" of a TabControl, and
less important information on other tabs.

A user has requested an additional tab with information of even more
limited use. So limited, in fact, only a few people would want to know
it even existed, for the rest it's simply confusing.

So is there a way to hide/show whole tabs, INCLUDING the tab selection
thingy (what you click on to select the tab) itself?

Maury


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hide a worksheet tabs tleehh Excel Worksheet Functions 4 October 20th 08 04:51 PM
hide worksheet tabs Roxy Excel Programming 5 January 31st 08 01:35 AM
hide tabs from view then lock tabs? slowboat Excel Discussion (Misc queries) 1 December 19th 07 07:06 AM
Hide Worksheet Tabs Beep Beep Excel Discussion (Misc queries) 2 September 20th 07 10:27 PM
hide the tabs Pietro Excel Discussion (Misc queries) 2 February 17th 07 04:38 PM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"