automatically enable macros on file open
Okay, so I'm working on the publishing and distribution of my huge automation project. For a number of reasons I have chosen to create a workbook with buttons that trigger the various automations. It also includes tabs with instructions for the various processes and such. I am not particularly concerned about users altering my code. And they got very scared when I used the phrase "add-in". This is the best way to go.
Now I have one little idiot-proof I'd like to code in. When a user opens this particular file I'd like to prevent the "enable/disable macros" message from appearing at all. Instead I'd like to simply force the macros to be enabled and not let the user have any say in the matter.
I'm sure this is easy to do, but need someone to point me in the right direction.
Video Tutorials / Excel Dashboards Reports