How do I share macros?

[Guest]

I want to create macros and get them to other users in my group so they can
use them. what is the best way to do that?

 

[Guest]

hi,
export the macro through the vb editor to a public drive
then have your other users import the macro through the vb
editor.
to export.
open the vb editor(alt+F11). on the left side, click
your project to expand it. right click the module the
macro is in. click export. it will save as with a .bas
file extention.
To import.
open the vb editor(alt+F11). on the left side, Right click
your project. click import. brouse to find the file.

 

[Bob Phillips]

Create an addin with the macros, and install on all machines.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

I like Bob's suggestion of creating an addin, but then you have to give the
users someway of executing your macros.

John Walkenbach's menumaker adds menu items on the fly. It's really simple to
use. You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm

If you want a toolbar, here's how I do it:
http://groups.google.co.uk/[email protected]

It's not quite as pretty as John's, but I try to keep the number of items on a
toolbar less than a dozen or so. (I find the menus much nicer.)