Trusted Location in Excel

If you are Excel VBA user and you don’t know about Trusted Location setting, You missed something more even you may be in trouble.

You should use a trusted location to store a file when you don’t want that file to be checked by the Trust Center, or if you don’t want it to open in Protected View. This applies particularly to files with macros, data connections, ActiveX controls (what we call active content).

If you think the active content in a file is from a reliable source, it’s better to move the file to a trusted location, instead of changing the default Trust Center settings to a less-safe macro security setting.

Add a trusted location
Click File > Options.

Click Trust Center > Trust Center Settings > Trusted Locations.

Click Add new location.

Click Browse to find the folder, select a folder, and then click OK.

Remove a trusted location
Click File > Options.

Click Trust Center > Trust Center Settings > Trusted Locations.

Select the location to be removed, and then click Remove, and then click OK.