VBA automatically agree to enable macros

Question

I have a VBA code that is opening a lot of different excel files with macros. However, every time VBA opens a file, it says "Microsoft Office has identified a potential security concern", and I have to select "Enable Macros". Is there a way to add a line, that would always choose "Enable Macros", as I cannot change any excel settings (it is a corporate computer, without admin rights)?

Thank you!

Answer 1

Typically when opening a macro-enabled file using code, there's no security prompt. It would help to show the code you're using to open the files.

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

See: https://docs.microsoft.com/en-us/office/vba/api/excel.application.automationsecurity