Enabling Macros automatically when document is opened

[Rohan Kharvi]

When document is opened it is asking to enable the macros. Without doing the manual setting (> options > security > macros > enable) how to enable macro automatically. This is one of our project requirement . I know this is there for security reason, is there any options to do the same.

[macropod]

It is not possible to change that setting programmatically. If it were, virus/malware writers would have a field day.

[Guessed]

You can set a folder as a trusted location so that files with macros contained in that folder are automatically trusted. Typically, you set the templates folder to be a trusted location and ensure the macros are saved in templates, not documents.

See https://support.office.com/en-us/art...3-4e7c67147fb4