VBA code shared between .XLS files

[BitTwiddler]

I have lots of worksheet files that use the same VBA code. Currently I copy
the code from one file to the next. However, if there is an error in the VBA
code, I have to go to ALL the files and update it, which is a royal pain.
Combining all the files into a single file is not practical. How can I have
a single copy of the VBA code that is used by all the files?

 

[Sheeloo]

Create a worksheet with the macros you want.
Choose Window, Hide and then save it to
C:\Program Files\Microsoft Office\Office\Xlstart (assuming you used the
default location when you installed Office).

To add/modify macros in personal.xls, choose Window, Unhide to unhide
personal.xls. After you finish storing your macros, choose Window, Hide to
hide personal.xls again.

 

[Chip Pearson]

Write an XLA add-in. Then when code needs updating, you just update
the one XLA file. See http://www.cpearson.com/Excel/CreateAddIn.aspx
for the basics for writing an XLA. They're quite simple.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)