Macros are so useful and big time savers and there are times we want to run them automatically when we open a document or close one.
I've seen a number of complicated ways to do this but it is really as easy as giving a macro the correct name such as autopen and autoclose.
Here in this video I show you how to do this and also create prompts using input boxes.
If you want to see more then check out my website http://www.jargonfreehelp.com
This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0
I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.