See Chip Pearson's page on working in the VBE with code:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"LarryP" wrote in message
...
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.)