How do I save a 2003 version macro in separate folder for other u.
 

I know how to create a macro (I have 2003 version) however I can't figure out
how to save it to a folder that I can place on a shared drive so others can
use it, as well.

How do I save a 2003 version macro in separate folder for other u.
 

notanITperson,
Macros require a container, in this case Excel I imagine. You need to save
the workbook that contains it/them to the shared drive, then other can
open/copy/use as desired.
Other than that look into templates (.xlt) or addins (.xla, .xll).

Hope that helps.

NickHK

"notanITperson" wrote in message
...
I know how to create a macro (I have 2003 version) however I can't figure
out
how to save it to a folder that I can place on a shared drive so others
can
use it, as well.