Separation of VBA Code and spreadsheet

  • Thread starter Thread starter Wes Jester
  • Start date Start date
W

Wes Jester

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 (e-mail address removed)
 
Back
Top