Workbooks within workbooks

[phil2006]

My workbook has a lot of sheets in it now and I was wondering if it'
possible to have a workbook within a workbook. i.e. when you ope
certain sheets the sheets available to open along the bottom change?

Thanks



Phi

 

[Tim Marsh]

i'm not sure i understand correctly what you are trying to achieve, but you
could hide / unhide sets of sheets. the un/hiding could be controlled by: -
- something on the active sheet (eg, a button)
- an contents page (ie, a list of available sheets on the first worksheet)
- a toolbar
- a userform
- probably several other ways too!

for any of these, you would need to have a bit of code to un/hide the
desired sheets

hth,

Tim

 

[NickHK]

Phil,
You can Hide/Unhide worksheets, Format > Sheet > Hide. You can select
multiple sheets by holding down the control keys whilst you select the
desired sheets to group.
Combine this with Custom Views, View > Custom Views.., and should be able to
give the appearance of what you want

NickHK

 

[Norman Jones]

Hi Phil.

This is not an available feature.

However, it would be feasible to write event code to hide and unhide sets of
sheets according to which 'master' sheet is selected.