I created a macro for a user and am looking to have it available to everyone
in the office. For the life of me I can't find any information about how to
make this happen. Anybody know how to do this?

"Jim Neal" wrote:

I created a macro for a user and am looking to have it available to everyone
in the office. For the life of me I can't find any information about how to
make this happen. Anybody know how to do this?

Here's the basic idea:

Make a spreadsheet with that macro in it, place it in a well-named module
Save it as an XLA
Put the XLA somewhere on your network that everyone can get to
Go around to the machines, and import that XLA as an Add-In (Tools menu?)

From now on if you want to add more functionality, simply add it into that
XLA. The next time people open XL they'll get your new code. The only problem
is that you might have to ask people to quit out so you can get the lock on
the file (you'll know what I mean when it happens).

Maury