Sub Tabs

[kpierce]

Hello All -
I have been developing an excel file with multiple tabs, and it just continues to grow.

Is there an EASY way to create sub tabs? I am not even sure how this would look or even work. But for example, right now I have three informational tabs: Program, Project, EarnedValue. I would like to show just one tab called Informational, then some how allow the user to select Program, Project or EarnedValue as the sub tab, then show the information. (these are just text, support tabs)

I know you could probably do this with a tab control in VBA, but again I am wanting to keep this as simple as possible. (hoping for some type of built in type functionality).

I guess another option would be to place this all on the same tab and have links at the top for the three sections.

Any thoughts?

Thanks in advance..........

BTW: I am using Excel 2003 and/or 2007.

 

[VoG]

Try Autofilter http://www.contextures.com/xlautofilter01_2003.html and http://www.contextures.com/xlautofilter01.html