Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with a template - referencing and activating
Using Office 2003 and Windows XP;
I am opening a file as a template (Workbooks.Add) to keep users from damaging a form that is opened from a button on a toolbar. However, because the template is unsaved, it's a bit harder to work with. For example: Workbooks("TemplateName").Activate The above didn't work for me to switch back and forth between files. Is there another way to reference an unsaved template file so I can activate it when needed? Just personal preference, but I'd rather not use an object reference when it is added, however, I will if it is necessary...if this is the only way, could someone please post example code on how to get the object reference? --- and then, does the object reference stay available even though the file loses focus? Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT not working as expected - referencing multiple dynamicranges | Excel Discussion (Misc queries) | |||
Remove the Task Pane when working in a template | Excel Discussion (Misc queries) | |||
Working within a workbook without activating it? | Excel Programming | |||
Activating/De-activating buttons | Excel Programming | |||
Working within a workbook without activating it? | Excel Programming |