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

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia