Sheet Tabs

[Keegbaba]

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!

 

[Mike H]

Hi,

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

Mike

 

[Gord Dibben]

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