Separation of VBA Code and spreadsheet

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem sorting a range of columns using VBA 1
VBA to copy from one workbook into another 0
Simple shared code library, also how to find spreadsheets with macrosin them 1
Sort a range of strings using VBA code? 5
Code to copy data 7
VBA Macro Training in Chennai 0
VB Error in spreadsheet with no VBA code 2
Use VBA to create new sheet with event handlers in sheet's code 2

Top