Grouping Tabs

[vlefebvre]

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

 

[CyberTaz]

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 |:>)

 

[RagDyer]

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!
==============================================

 

[CaliberX]

Great Tip 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