Was asked about hierachical sheet tabs, for example, two tabs 'A' and 'B'
where when you click on 'A' you then get a series of sheets just for that
group, and clicking on 'B' you get a different series of sheets. I know all
this is easily within the grasps of VBA but if programming is not pursued, is
this function resident in the program? Thanks!

Hi,

I don't believe there is any way of doing that with code.

Mike

"Keegbaba" wrote:

Was asked about hierachical sheet tabs, for example, two tabs 'A' and 'B'
where when you click on 'A' you then get a series of sheets just for that
group, and clicking on 'B' you get a different series of sheets. I know all
this is easily within the grasps of VBA but if programming is not pursued, is
this function resident in the program? Thanks!

A sheet cannot have sub-sheets...............not even within the grasps of
VBA.

Worksheets reside within workbooks.

Each workbook can have multiple sheets.

With VBA you could hide certain sheets in a workbook then swap those to
unhidden and hide others.

Nothing resident within Excel to do what you want.


Gord Dibben MS Excel MVP

On Mon, 15 Dec 2008 11:20:05 -0800, Keegbaba
wrote:

Was asked about hierachical sheet tabs, for example, two tabs 'A' and 'B'
where when you click on 'A' you then get a series of sheets just for that
group, and clicking on 'B' you get a different series of sheets. I know all
this is easily within the grasps of VBA but if programming is not pursued, is
this function resident in the program? Thanks!