I have saved a simple macro saved in the personal.xls worksheet of several Excel users where I work. I now need to edit that macro and wondered if there was a way of automating this to save me manually going to everyone's PC and typing in the code, i.e. perhaps by sending an excel file to everyone that they open and then click a button which updates their macro? Is that possible?
Thanks