Hi,

I have to agree with these guys, an Add-In would be preferable to a dummy
workbook, and then your code would be available to all workbooks you use.
However, if you only require that code for one specific workbook then you
might as well keep it there. If anything, having to open two workbooks would
make things slower, although closing might be slightly faster as only one
workbook would need to be saved.

If the workbook is taking a ridiculous amount of time to open then I'd look
at trying to tidy the data, or reducing the code if possible. One thing that
can cause lengthy delays is the calculation of formulae when you open a
workbook. Say, for instance, you have a formula in one column and it spans
thousands of rows, but it doesn't need recalculating once you have the
results, then you can copy the column and use paste special to paste the
values over the same area. This is something I often do to keep calculations
to a minimum.

Sean.

"Susan" wrote:

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