Excel Trust Center Setting Modification

For testing, I needed a quick way to switch Excel Trust Center settings between restrictive and permissive. Using Process Monitor and these settings, I was able to observe the registry keys and settings Excel’s Trust Center uses to store values.

Using these key/values, I created a VBScript file to automate switching between restrictive and more permissive Trust Center settings.
The script needs to be executed when Excel is not running.  The new settings will be applied the next time Excel is run.

Excel Trust Center Settings
Excel Trust Center Setting Process Monitor
Trust Center Script Dialog
Trust Center Script Dialog

Selecting Yes will set the following Excel Trust Center settings :

Trusted Locations :
Turn off Allow Trusted Locations on my network

Trusted Documents :
Turn off Allow documents on a network to be trusted

Add-ins :
Turns on Require Application Add-ins to be signed by Trusted Publisher

ActiveX Settings :
Turns on Prompt me before enabling Unsafe for Initialization (UFI) controls with additional restrictions and Safe for Initialization (SFI) controls with minimal restrictions

Turns on Safe mode

Macro Settings :
Turns on Disable all macros with notification
Turns off Trust access to the VBA project object model

Protected View :
Turns on Enable Protected View for files originating from the internet
Turns on Enable Protected View for files located in potentially unsafe locations
Turns on Enable Data Execution Prevention mode

External Content :
Turns on Disable all Data Connections
Turns on Disable automatic update of Workbook Links

Selecting No will set the following Excel Trust Center settings :

Trusted Locations :
Turns on Allow Trusted Locations on my network

Trusted Documents :
Turns on Allow documents on a network to be trusted

Add-ins :
Turns off Require Application Add-ins to be signed by Trusted Publisher

ActiveX Settings :
Turns on Prompt me before enabling all controls with minimal restrictions

Macro Settings :
Turns on Enable all macros
Turns on Trust access to the VBA project object model

Protected View :
Turns off Enable Protected View for files originating from the internet
Turns off Enable Protected View for files located in potentially unsafe locations
Turns off Enable Data Execution Prevention mode

External Content :
Turns on Enable all Data Connections
Turns on Enable automatic update for all Workbook Links