VBA code shared between .XLS files
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.
"BitTwiddler" wrote:
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?
--
John
|