Excel: Best way to update macro's?

Hello Guys, I am trying to figure out the best way to update macros on my coworkers macros. They all have workbooks saved on there computer tailored to there specific terminals they cover. However they all use the same macro's (email macros, formatting macros, etc) embedded into each of there workbooks. Every time I want to update there macros I have to do it about 50 times for each workbook. I am wondering if there is a way to have peoples macro's to automatically update when I update a master macro file or have the ability to create a new macro that will automatically install on everyone's workbook. I have done research on this online and people are saying to create an add-in then somehow work it into a template. But I do not understand how this will automatically update there macros or add new macros to there workbooks. They can not create a new workbook everyday they have to use the workbooks they already have because all of there data is in there with tons of formulas, charts, etc. Can someone please help me out?

This question generated 18 answers. To proceed to the answers, click here.

This thread is current as of August 26, 2014.

For more resources for Microsoft Excel