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