Sharing a Excel VBA macro

[SteveQL]

I have a macro that I wrote in VBA that is pretty useful to a lot of people in my office. Is there a way to compile and share macros? Or I guess more to the point, what is the best way to share a macro that needs to exist in a persons Personal.xls?

Thanks for your help!

Cheers!
Steve

 

[jfhewitt]

Copy your macro to notepad. Have friend record dummy macro, paste your macro into the new macro. Viola!