VBA automatically agree to enable macros

Question

I have VBA code that uses macros to open numerous distinct Excel files. I must choose "Enable Macros" every time VBA opens a file since it states that "Microsoft Office has found a potential security threat." I can't modify any Excel settings because it's a business machine without admin permissions. Is there a way to add a line that would always select "Enable Macros"?

Answer 1

Typically, there is no security alert when opening a file with macro support using code. The code you're using to open the files should be displayed.

However, if you do see a prompt you can fix that by setting Application.AutomationSecurity to the appropriate value