How to set up macro to be used from a central location?

[mbanwart]

Windows XP, Excel 2007

I maintain a macro that is used by several people. Until now, I have had to reload the macro on to each individual's laptop every time I made a change. However, this is becoming a very time consuming & cumbersome process.

I have exported the macro to a shared drive that all individuals can access. How do I set this up so that people can use the macro from the shared drive without importing it from the shared drive onto their laptop every time it's updated?

Mary

 

[shg]

You could implement it as an add-in, stored read-only on the network share.

See http://www.fontstuff.com/vba/vbatut03.htm