I have a set of macros in a template/starter file for users to open and start a project. Within this workbook contains a bunch of macros. Instead of sending everyone a new workbook with updated macros each time, I would like to host these macros or somehow distribute updated macros to everyone efficiently.
I am unsuccessful in finding a way to have a button call another macro from a workbook on a network drive.
I am also unsuccessful in using an addin. I have saved the macros as an add-in and added it to my workbook, but am unable to call those functions.
I could also just export the modules each time one updates but then I have to rely on the user to replace their current one which I don't want to do.
Essentially, I would like the update to occur without relying on the user to do very much or anything at all.
Thanks
Bookmarks