ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I hide tabs? (https://www.excelbanter.com/excel-programming/422782-can-i-hide-tabs.html)

Maury Markowitz[_2_]

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

Dave Peterson

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


All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com