At the moment, all of the VBA code we use is stored locally on my computer in my Personal Workbook file. However, I am interested in migrating 3-4 modules of code so other users can use these macros. As the code needs to be updated on a regular basis and used on more than one file/project, it is not efficient to store the macros in each file rather than the Personal Workbook. Any suggestions on how the macros can be stored centrally on the server and accessed by any user who has access to that server rather than copying to each user's computer every time an update occurs?
Bookmarks