Build them as an add-in.
http://www.fontstuff.com/vba/vbatut03.htm
Fester Bestertester wrote:
Excel 2003, Win XP:
Okay, I'll admit, I'm something of a newbie at Excel programming.
I've created a custom menu which runs a series of macros. Can I
distribute these to other users within my network by saving them out to
a shared directory? How, in general, would I go about distributing a
custom menu and the macros that the menu is supposed to run?