Sheet Tabs
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! |
Sheet Tabs
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! |
Sheet Tabs
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! |
All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com