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
Any help on this would be GREAT!
Thanks!
ragamuffin