PDA

View Full Version : Sharing Macros



ragamuffin
12-16-2006, 10:01 AM
So, if you have a macro, or several macros, stored in Personal.xls, and you need to send the workbook to other users via email, how do they have access to those macros? The workbook serves as a template, so I can't save the macros in the workbook itself, because daily it will be opened and Saved As, so the code needs to work for the newly created file. I also have two of the macros linked to custom toolbar buttons, so I need those shortcuts to transfer too. I am thinking that if the macro will transfer with the workbook, the shortcuts should as well, but I am not sure - I have never had to share a macro among many users before.

Any help on this would be GREAT!

Thanks!

ragamuffin

mdmackillop
12-16-2006, 10:14 AM
Copy your macros into another workbook and save it as an Add-In, XLA file. This can be installed on each user's PC or shared from a server for easier maintenance.
My KB item here uses an add-in http://vbaexpress.com/kb/getarticle.php?kb_id=780

mdmackillop
12-16-2006, 10:33 AM
Check out Ken's item here on implementing add-ins
http://www.excelguru.ca/node/45

ragamuffin
12-16-2006, 11:57 AM
Thanks again, mnmackillop. I will have to do some reading and figure it out, I have never created an add-in before. I'll let you know how it turns out.