Microsoft Office on laptop
Vladimka production/Shutterstock.com

The next time you download a Microsoft Office file, you’ll have one less thing to worry about, as Microsoft is blocking Visual Basic for Applications (VBA) macros by default in downloaded files.

“The default is more secure and is expected to keep more users safe, including home users and information workers in managed organizations,” says Kellie Eickmeyer, a principal PM at Microsoft, in a blog post.

People would have malicious macros inside Office files, so when you ran them, they could install malware. When this change goes live, Microsoft will make it so clicking on these macros won’t run them by default in Access, Excel, PowerPoint, Visio, and Word.

The specific wording of the change is “VBA macros obtained from the internet will now be blocked by default.” Basically, that means that when you download an Office file and open it, any VBA macros within it will be blocked automatically and you’ll have to manually override for each file.

Advertisement

Unfortunately, that also means that legitimate macros will also not work. If a coworker sends you an Excel file with VBA macros in it, you’ll need to manually enable them through the file’s properties menu. It’s an extra step, but considering how prevalent these malicious macros are, it might be worth it.

As far as when this change will go live, Microsoft said that it plans to add it to Version 2203, starting with Current Channel (Preview) in early April 2022. It’ll roll out to other Office update channels later, though the company didn’t get more specific.

Profile Photo for Dave LeClair Dave LeClair
Dave LeClair was the News Editor for How-To Geek. He started writing about technology more than 10 years ago. He's written articles for publications like MakeUseOf, Android Authority, Digital Trends, and plenty of others. He's also appeared in and edited videos for various YouTube channels around the web.
Read Full Bio »