Microsoft Has Blocked Macros from Running Quick 3 Methods
Published: November 20th, 2025 • 5 Min Read
If you are seeing that Microsoft has blocked macros from running error in Excel, PowerPoint, or Word. It simply means that Microsoft 365 has identified macros from an untrusted source and blocks them from running. The answer to overcome your problem is to unblock macro files via the properties tab.
However, this process is only recommended if you trust the source of the macro files. Otherwise, unblocking unsafe macros may cause a security breach on your PC or within your Microsoft 365 environment.
Secondly, in this blog guide, we will discover 3 tested ways to unblock macros in Microsoft, including a DIY and a professional-grade solution.
Is it Safe to Unblock Macros in Microsoft Word, Excel, or PowerPoint?
No, it is not safe to unblock macros in Microsoft Excel, PowerPoint, or Word unless you trust that your Microsoft macros file is from a safe external source.
Suppose you do not trust the source of the macro files. Then, it is not recommended to unblock, as the potential malware in macro files can auto-install on your PC and cause damage.
Why Does Microsoft Has Blocked Macros Error Occur?
The error “Microsoft has blocked macros from running” occurs because the source of the file is untrusted. This happens when files downloaded from an external source, like the internet or an email attachment, are tagged with a special security marker called the Mark of the Web.
This alternative data stream (ADS) is automatically added to files by the Windows OS. Therefore, when Microsoft 365 detects this tag, it blocks the macro-enabled files, resulting in the error indicating that the file’s source is untrusted.
DIY Ways to Unblock Macros in Microsoft
Windows has built-in methods to unblock macro files. One, we can opt for the Windows properties tab option that can remove the security tag from the macros files and instantly fix Microsoft has blocked macros from running error.
Secondly, we can use the Microsoft Trust Centre settings to fix this error. However, this second approach will not remove the security tag from the macro files; It will just bypass it and allow Microsoft to run macros.
Now, let us discuss the detailed working steps of each technique in an easy-to-follow way.
How to Unblock Macros in Microsoft via the Properties Tab Option?
- First, locate the macros file blocked in Microsoft in File Explorer.
- Next, right-click on the file and click on the Properties option.
- Then, look for the Security option at the bottom and check the Unblock option.
- Finally, try to rerun the macro file in Microsoft and check if your error is solved.
Fix the Microsoft Has Blocked Macros Error Using Access Centre Settings
- At the start, go to the file tab on Microsoft Excel, Word, or PowerPoint.
- Next, click on the Options button in the bottom left corner.
- Then, click on Trust Centre > Trust Centre Settings > Trusted Locations.
- Now, click on the Add New Location > click the Browser button.
- After that, select the Microsoft macros file location that is blocked while running.
- Finally, click ok and check if the Microsoft blocked Macros from running error is solved or not.
Limitations of the DIY Approaches to Unblock Macros
- The properties tab method does not support unblocking multiple macro files at once. You need to individually locate each macro file and follow the same set of steps described in the above section.
- Following the same set of steps again for multiple macro files is a very time-consuming process. Secondly, in the manual process, there is a risk that untrusted macro files will also get unblocked due to human error.
- The above-discussed DIY approach is not suitable for organization purposes. Since unblocking hundreds of macro files via DIY techniques is a very unproductive approach.
Professional Way to Fix Microsoft Has Blocked Macros Error
If you smartly need to unblock macro files in Microsoft by keeping the mark of the web data stored. Then you may use the dedicated Mark of the Web Remover Tool. This specialized macro unblocker utility is developed with the functionality to unblock multiple macros at once and export the mark of the web data in CSV format. Using this application, users can fix the Microsoft has blocked macros from running error in Excel, Word, PowerPoint, etc. Now, let us discuss how to use this expert utility.
How to Unblock Macros in Microsoft Using Expert Utility?
- At the start, install and run the suggested macro unblocker tool.
- Next, click on the Select Files or Select Folder option to add macro files.
- Then, select the macro files that throw errors that need to be unblocked.
- Now, check the export report option and choose the destination path.
- Lastly, click on the remove button to fix the macros blocking error in Microsoft.
Concluding Words
In conclusion to the above blog on the topic of Microsoft has blocked macros from running error, how to fix guide. We have started this blog post by understating the meaning and cause of this error. Moreover, we have seen how we can fix this error easily using the Windows built-in ways. However, these methods are full of imitations. Secondly, we discussed a professional-grade solution that unblocks hundreds of macro files at once. Lastly, we have seen the working step of this expert-suggested utility.