Hi Trfor,

Put the code into a separate workbook and save the workbook as an addin.
Intall the addin (Excel Menus | Tools ! Addins | Check the Addin).

---
Regards,
Norman



"Trefor" wrote in message
...
I have about 50+ workbooks each with 4000+ lines of code in them and I am
still developing the code so updating the code in all 50+ wookbooks when I
want to apply a change in a major pain in the you know what!

I have a few idea's but wanted to know what the guru's here might have to
say.

Currently - I update the code in one master woorkbook, then I have
written
code that will import all the worksheet data from the "other" open
workbook
into the master. I then "File Save As" the master to a new name to replace
the "old" workbook. The problem with this is I have to do it 50+ times.

Idea 1 - I move all the macro's to another workbook and put it in my excel
startup folder. Each time excel is run I should have access to all my
macros
right? Then if I update the macro's I only need to do it once right? The
only
catch I can think of is if I want to change the worksheet(s) format as
well.
Is it possible to specify the path to the "macro workbook" in the workbook
that will use them?

Idea 2. - Is there some way of automating or scripting my current
situation.

Idea 3. - Is there some way of the workbooks checking a "master" workbook
and updating themselves at startup?

Idea 4. - A variation of 3, some code that I could include in the
workbooks
that if the user pressed a button it would go and check for an update and
either do 2 or 3 above.

Idea 5. - Something I have missed?



--
Trefor