Grouping Tabs
 

I have a large number of sheets my workbook. Is there a way to "group"
sheets together and have some kind of control to only activate one
group at a time so that only the relevant tabs are visible?

Again - Thanks for all of your time and efforts.

CaliberX

One option is to Hide the sheets that aren't in a group and create a Custom
View from the View Menu. Do the same for each group. You can add a combo box
on any toolbar that provides a list of Custom Views as a convenient way to
switch from one group of sheets to another.

I'm sure other methods will be offered, as well, so keep checking back for
more replies.

HTH |:)

" wrote:

I have a large number of sheets my workbook. Is there a way to "group"
sheets together and have some kind of control to only activate one
group at a time so that only the relevant tabs are visible?

Again - Thanks for all of your time and efforts.

CaliberX

See if these help:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



wrote in message
ups.com...
I have a large number of sheets my workbook. Is there a way to "group"
sheets together and have some kind of control to only activate one
group at a time so that only the relevant tabs are visible?

Again - Thanks for all of your time and efforts.

CaliberX

Great Tip :P Exactly what I was looking for.

Is there a way to change the order of the custom views in the combo
box?

Thanks again.
Caliberx