Is there a way to save macros in an add-in or something so that I can save a macro-enabled workbook to a share drive for people to access and use?
Right now the document I created only works for people who have newer computers. For everyone else I have to sit at their desk and save the doc as a regular excel file then add the macros in manually and save it as macro-enabled. I would really rather not have to do this for 15 people every time there is a change on the form. The document I created is not a shared file, it is a regular workbook that people can save to their desktops and use at their leisure. Can anyone give me any suggestions?
Thanks in advance.
Right now the document I created only works for people who have newer computers. For everyone else I have to sit at their desk and save the doc as a regular excel file then add the macros in manually and save it as macro-enabled. I would really rather not have to do this for 15 people every time there is a change on the form. The document I created is not a shared file, it is a regular workbook that people can save to their desktops and use at their leisure. Can anyone give me any suggestions?
Thanks in advance.