Hi All,
I had a repetitive job in excel and I have recorded a macro for it after a long time. How can I now share the same macro to the team members to make the task easy for all.
Please advise.
mady
Hi All,
I had a repetitive job in excel and I have recorded a macro for it after a long time. How can I now share the same macro to the team members to make the task easy for all.
Please advise.
mady
Either include it in the workbook you are distributing or distribute it as an xla (add-in).
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
When I click on view macros and edit, I get the option to export the code out as ".CLS". Now I can I import into any other sheet or as an add-in. Please tell me in details.
Check out Martin Green's site for creating an add-in http://www.fontstuff.com/vba/vbatut03.htm
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Got it.. thanks Simon