thanks in advance..........

i have several large workbooks. a couple have very large &
complicated macros associated with them, and therefore take a long
time to open & close.

can i.........
have a much smaller macro in the data workbook, that when a button to
"run" a macro is clicked, will simply open up a dummy workbook & then
run the code from there????? at the end of the session, when the data
workbook is saved & closed, the dummy workbook would also close.
almost all of the macro coding would be stored in the dummy workbook.

i'm willing to try to figure it out myself, but if it's not possible
then i'd like to save myself massive headaches. :)

(i'm assuming that the userforms would have to be in the data
workbook, but i could direct all the coding from it to the dummy
workbook - if it's possible.
thanks!
susan