If you’ve recently downloaded an Excel macro enabled workbook from the internet, you may have noticed that the file comes up with a message saying “microsoft has blocked macros from running because the source of this file is untrusted”. This error was introduced by Microsoft in 2022 as a way to protect its users from malicious files that can harm their computers and potentially expose their data to hackers. This is a great idea and it has helped many people stay safe, however some users have found the error very frustrating.
In this article, we will explain how to fix this problem so that you can open and run macros from the internet without getting the annoying warning message. The solution is surprisingly simple and should only take a few minutes to do.
To get rid of this error, you will need to make the location where the macro-enabled file is saved a Trusted Location. To do this, right-click on the workbook and select Properties from the menu that appears. Then, click the General tab and place a check mark in the “Unblock” box. Once you’ve done this, re-open the workbook and you should no longer receive the Microsoft has blocked macros from running error message.
We recommend creating a new folder on the desktop and making it a Trusted Location so that only files you deliberately save there will be allowed to have macros. This is one of the easiest ways to bypass this restriction and should help you avoid getting the annoying error message in the future.