Microsoft has stopped blocking VBA macros in Office files, but this will soon change

Last week, Microsoft unexpectedly stopped blocking Visual Basic for Applications (VBA) macros in Office. But this move was a temporary change. The Redmond firm is still planning to disable VBA macros by default to improve security, but this will happen a little later.

Microsoft first announced its intention to get rid of VBA macros in February 2022. But suddenly files downloaded after June 30 allow running them again.

Microsoft Will Soon Make Office VBA Macros 2

Kellie Eickmeyer, company's Principal Product Manager, has announced the change as follows.

Following user feedback, we have rolled back this change temporarily while we make some additional changes to enhance usability. This is a temporary change, and we are fully committed to making the default change for all users. 

So now macros are blocked by default, but to enable them, it was enough to click on the button in the warning box in Office apps. In the future, this button will lead to the Microsoft support site.

Microsoft has not yet announced the changes it plans to make to improve usability. But they are going to shed some light on this in coming weeks.

Initially, the company wanted users to go to the properties of the downloaded Office file and agree to unlock the file. After this Office would allow macros in the file to run. This can be difficult for an average user, so  the firm will soon offer a better  UX solution.

Currently, Microsoft provides a couple of group policy settings that define what Office apps should do with VBA macros. The system administrator can block or allow them, and also specify trusted locations in which macros are always allowed.


Support us

Winaero greatly relies on your support. You can help the site keep bringing you interesting and useful content and software by using these options:

If you like this article, please share it using the buttons below. It won't take a lot from you, but it will help us grow. Thanks for your support!


Author: Sergey Tkachenko

Sergey Tkachenko is a software developer who started Winaero back in 2011. On this blog, Sergey is writing about everything connected to Microsoft, Windows and popular software. Follow him on Telegram, Twitter, and YouTube.

Leave a Reply

Your email address will not be published.

Using Telegram? Subscribe to the blog channel!
Hello. Add your message here.