How do I make a copy of a macro?

[jjnotme]

Hi:
Please tell me how to make a copy of a macro in excel 2003. I need to
make copies of several macros and I just don't know how.

Thank you.

Carol.

 

[Jon Peltier]

Not sure what you mean.

Select the text and copy?
Right click the module in the project explorer window and choose Export?

- Jon

 

[Gord Dibben]

It would depend upon what you want to do with the copied macros.

Could you give us a hint?

To copy a macro go to Tools>Macro>Macros.

Select a macro bty name and "Edit"

Copy the macro and do something with it.


Gord Dibben MS Excel MVP