How can I "permanently" enable macros on my own-made spreadsheets

Hello

I have an infuriating problem (which I'm posting here, as it isn't Office 365, but stand-alone Excel for Mac)...

Most of my Excel files contain macros. However, I occasionally use Excel files from others.

I would like to be able to "permanently" enable the macros in the files I have made, and not respond to the enable-macros question each time I open one of my files. BUT, for security reasons of course, I still want the option to enable macros in other alien files.

When I look at the interface in Excel, it appears it is an all or none enabling of macros that can be set "permanently".

Does anyone know how to just specific enable "permanently" for my specific spreadsheets?

Thanks.

As far as i know, it would be all or nothing as you stated. But you can try the trust center:

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

Mmm... I was afraid that might be the case.
I don't think there is a Trust Centre for Mac ...
I seem to vaguely remember that it was in competition with something called Sandbox.