If you ended up in this article, you should have already seen the message "Microsoft has blocked macros from running because the source of this file is untrusted." Microsoft has recently started to show this message in Office products when users open a file that came from the internet, such as an email attachment, and that file contains macros. Although there are good deeds behind the feature, it becomes annoying as you see the message over and over. In this article, we are going to show how to get rid of Microsoft has blocked macros messages in Excel.
Unblocking the file
The first approach is for whom they want to deal with files separately and manually.
- Before opening your file, locate it in File Explorer.
- Right-click on your file and click Properties Alternatively, you can press Alt + Enter key combination as well.
- Check Enabled
- Click OK to apply.
After the final step, you can open your file without an annoying message.
Trusted Locations
Alternatively, you can add the folder where you download files into (usually "Downloads") into Excel's Trusted Locations. Once set, Excel will not show you the message for the files located in that folder.
Be warned that, if you moved the file a folder that isn't a trusted folder and run, you see the message.
Follow the steps to get rid of Microsoft has blocked macros message:
- Open Excel options by following File > Options.
- Open Trust Center
- Click Trust Center Settings
- In Trust Center window, activate Trusted Locations
- Click Add new location button to open Microsoft Office Trusted Location
- Use Browse button to select the folder.
- Click OK buttons to apply the setting.
