For testing, I needed a quick way to switch Excel Trust Center settings between restrictive and permissive. Using and, I was able to observe the registry keys and settings Excel’s Trust Center uses to store values. Using these key/values, to automate switching between restrictive and more permissive Trust Center settings.
It requires 'Enable all macros' and trust access. I have an existing macro that opens this file to extract data. Is there a VBA that would update the Trust Center to allow for this file then revert back to the old settings.
![Excel For Mac Trust Center Excel For Mac Trust Center](/uploads/1/2/5/5/125587831/903972914.jpg)
The script needs to be executed when Excel is not running. The new settings will be applied the next time Excel is run.