For what it's worth, after all of the above:
I have a macro-enabled template containing over 100 procedures, which I'm constantly adding too or correcting. My colleagues are using all of these macros, accessed from a custom ribbon tab in Word; so how do I roll out updates?
1. Everyone has their own version of the macro-enabled template in their Word startup folder.
2. I have put a copy of this template in a network location available to everybody.
3. I run an update macro when I'm happy with my corrections/additions which overwrites the network version.
4. I tell my colleagues I've made some change by email.
5. They have a similar update macro in their Normal.dotm which is accessible via a custom button on the Word ribbon.
6. This macro copies the network version and overwrites their own version.
So it's all done with clicking buttons on the ribbon. The basic code structure I found here: https://wellsr.com/vba/2018/excel/vb...-fso-copyfile/