Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) | |||
Workbooks.Open closes other workbooks | Excel Programming |