You'll want to save your code/forms into a single XLA file.
Then you can load that xla file with any number of XLS
files and have access to the code/forms of the single
XLA. This way you can manage your code from one source.
When you save-as XLA, Excel will try to force your XLA
file to the Add-in directory but it can actually be saved
and loaded from a network drive without a problem. One
note of caution...make sure the xla file is read-only to
regular users or else they will blow it up and you may
want to add protection to it to prevent them from looking
at the code depending on how paranoid you are...like me.
-Kevin



-----Original Message-----
Hello. I create alot of spreadsheets. Whenever one is
nearly done, I add
some additional code and forms to the spreadsheet. The
same code/forms are
added to each spreadsheet. I was wondering if there was
a way I could
automate this. I pretty much want to create some code
that will actually
create code in the spreadsheet's VBA environment. Is it
possible to do
something like this in VBA or even VB 6? I know you can
do it in VB 6 for
that environment. I just haven't been able to figure it
our for Excel.

TIA,
Bich Leu


.