Body
Issue
In Excel you receive an error that states "Microsoft has blocked macros from running because the source of this file is untrusted."

Environment
Microsoft Excel
Resolution
Solution 1:
- In Excel, go to File> Options > Trust Center > Trust Center Settings

- Under "Macro Settings" and "Developer Macro Settings", check the box for "Trust access to the VBA project object model"

- Next, click OK. You will then need to restart your Excel client and re open your workbook. If this doesn't help, move on to Solution 2 below.
Solution 2:
- Copy the file location of where the file is located. This may be on a Shared Drive, OneDrive or your local storage. In this example, I will use our MIS Drive.

- With Excel open, click on File > Options > Trust Center > Trust Center Settings...

- Under "Trusted Locations" you will want to click on "Add new location..." and paste the file path you copied earlier.

- Additionally, you can choose to change the link to the Root file of the drive so that all files within that location are trusted under your new configuration.
- In the example below, I remove the "\Certificates" folder and leave it to only show "Z:\Documentation".
- Make sure you click the check box that says "Subfolders of this location are also trusted".

- Once done, click OK, close Excel and re-load your workbook. You should notice that the error is now gone and your macros should work as they would normally.
Done!
Cause
Unknown