Add Macros to Someone Else's Personal.xls
Anybody know if it's possible to add a macro to somebody else's Personal.xls
with VBA? I occasionally write little utility macros that others would find
helpful, and would like to be able to E-mail them an Excel file with VBA code
that will take the macro-associated code and "install" it into their
Personal.xls. The only way I know to do it right now is to get on their
computer and do some cut-and-paste work. (Sending them an actual
Personal.xls file won't always work, since they may have their own macros
that I wouldn't want to overwrite.)
|