Wes,

If it will only be the same workbook being worked upon, why do you need to
separate them. Why not keep them together?

--

HTH

Bob Phillips

"Wes Jester" wrote in message
...
I am fairly new to using VBA and have a question regarding maintenance of
the VBA code

1. I need to separate the execution of the VBA from the spreadsheet. The
application will probably get updated often, and the user will not be
using
a new template, simply opening the saved workbook. Is there a method I
can
use in workbook_activate, or some other event, to "load" the current set
of
modules or at least point to a location where a "master" may be kept?


If you wish, you can e-mail me direct at