Workbooks within workbooks
 

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

--
phil200
-----------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...fo&userid=3509
View this thread: http://www.excelforum.com/showthread.php?threadid=55877

Workbooks within workbooks
 

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

"phil2006" wrote in
message ...

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

Thanks



Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=558777

Workbooks within workbooks
 

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

"phil2006" wrote in
message ...

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

Thanks



Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=558777

Workbooks within workbooks
 

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.


---
Regards,
Norman



"phil2006" wrote in
message ...

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

Thanks



Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=558777