title: 10 users need to be able to run the same macro in excel
body: <p>i have a server where resides an excel macro</p>
  
  <p>there will be about 10 users on 10 different workstations that will need to run that macro on their own worksheets.</p>
  
  <p>how do i run the macro from a centralized location by multiple users who want to run it on their own worksheets?</p>
  
  <p>the reason i need it centralized is because the macro will need to be updated constantly, and we cannot have it reside locally because then there would be 10 different instances of it</p>
  
  <p>as one of the answers suggests below, perhaps an add-in is the way to go? if i do create an add-in, how would it know that there is a macro update? would i have to distribute the add-in every single time i update the macro?</p>