PDA

View Full Version : Sharing a macro that is created by me



madhuri007
03-25-2011, 12:24 AM
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

Simon Lloyd
03-25-2011, 03:13 AM
Either include it in the workbook you are distributing or distribute it as an xla (add-in).

madhuri007
03-25-2011, 03:36 AM
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.

Simon Lloyd
03-25-2011, 03:56 AM
Check out Martin Green's site for creating an add-in http://www.fontstuff.com/vba/vbatut03.htm

madhuri007
03-28-2011, 11:44 PM
Got it.. thanks Simon :)