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 :)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.