Excel should allow tab groupings.

[Bassam Abdul-Baki]

The way the tabs work in Excel is not very efficient. It would be nice if
you can create groupings for tabs in Excel so that each set of tabs can be
placed in its own group. I'm currently working on an Excel document that has
about 30 sheets. A lot of sheets are related in one way or another (i.e.,
Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
acceleration). It would be nice to be able to group these in some way so
that scrolling is no longer problematic and finding the right tab becomes
faster and easier.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1-610f404617ef&dg=microsoft.public.excel.misc

 

[macropod]

You can re-order the tabs however you like, thus grouping them according to
your preferences.

Cheers

--
macropod
[MVP - Microsoft Word]

The way the tabs work in Excel is not very efficient. It would be nice if
you can create groupings for tabs in Excel so that each set of tabs can be
placed in its own group. I'm currently working on an Excel document that has
about 30 sheets. A lot of sheets are related in one way or another (i.e.,
Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
acceleration). It would be nice to be able to group these in some way so
that scrolling is no longer problematic and finding the right tab becomes
faster and easier.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1-610f404617ef&dg=microsoft.public.excel.misc

 

[Chip Pearson]

You might consider using tab colors to make your tab groups more
distinct.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Bassam Abdul-Baki" <[email protected]>
wrote in message
news:[email protected]...

 

[Don Guillett]

In addition to the other suggestions, you could set up a list on one sheet
with a double click event to quickly goto any sheet on which you double
click

 

[CLR]

Agreed.........I use a MasterMenu sheet on a workbook with about 40 sheets,
with buttons to go to each sheet directly, with all sheets being hidden.
Each sheet also has a "Return to MainMenu" button, so to go to any sheet from
any sheet is only two clicks away...........on the MasterMenu, the buttons
can be grouped for Visual optimum......maybe even pictoral, like an
Instrument Panel....click on an instrument picture and it takes you to that
sheet.........

hth
Vaya con Dios,
Chuck, CABGx3

 

[macropod]

Hi Chip,

Coloured tabs are only available on the more recent versions of Excel (2002
and later). Not enough reason for me to upgrade <g>.

Cheers

 

[Bassam Abdul-Baki]

I do. But it's still not efficient because you have to read all the tebs to
get to what you want.

You can re-order the tabs however you like, thus grouping them according to
your preferences.

Cheers

--
macropod
[MVP - Microsoft Word]

The way the tabs work in Excel is not very efficient. It would be nice if
you can create groupings for tabs in Excel so that each set of tabs can be
placed in its own group. I'm currently working on an Excel document that has
about 30 sheets. A lot of sheets are related in one way or another (i.e.,
Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
acceleration). It would be nice to be able to group these in some way so
that scrolling is no longer problematic and finding the right tab becomes
faster and easier.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1-610f404617ef&dg=microsoft.public.excel.misc

 

[Bassam Abdul-Baki]

Some of us are color blind.

You might consider using tab colors to make your tab groups more
distinct.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Bassam Abdul-Baki" <[email protected]>
wrote in message

 

[Don Guillett]

Chuck,
Maybe the double click would be less overhead for you. Just a thought

 

[macropod]

And some just can't be helped!

 

[Jim Cone]

Nearing release is my Excel add-in "Determine Colors". It adds a popup menu
to the cell right-click menu. It displays the cell color, font color, pattern color,
border color and the sheet tab color. (by name)
It may be of assistance to color blind Excel users. I am looking for comments
and feed back on the program. If you are interested, please email me and
I will forward it to you. Remove xxx from my email address.
--
Jim Cone
San Francisco, USA
(e-mail address removed)
http://www.realezsites.com/bus/primitivesoftware



"Bassam Abdul-Baki"
<[email protected]>
wrote in message
Some of us are color blind.

 

[JB]

Grouping pby color:

http://cjoint.com/?gdiebRItrq

Private Sub CheckGroupe1Visible_Click()
For Each f In ActiveWorkbook.Sheets
If f.Tab.ColorIndex = 45 Then
Sheets(f.Name).Visible = CheckGroupe1Visible.Value
End If
Next

Cordialy JB



Bassam Abdul-Baki a écrit :