In July of 2021, we released a new Excel Trust Center setting option to restrict the usage of Excel 4.0 (XLM) macros. As planned, we have now made this setting the default when opening Excel 4.0 (XLM) macros. This will help our customers protect themselves against related security threats.
Customers can manage this setting by following the instructions shared in the original blog:
Restrict usage of Excel 4.0 (XLM) macros with new macro settings control - Microsoft Tech Community.
Availability:
This setting now defaults to Excel 4.0 (XLM) macros being disabled in Excel (Build 16.0.14427.10000)
Per the original blog post, Administrators can also use the existing Microsoft 365 applications policy control to configure this setting. Get the latest Office Administrative Template files.
The Group Policy setting “Macro Notification Settings” for Excel can be found in the following path and registry key:
In addition, this policy setting can be managed with:
Administrators also have the option to completely block all XLM macro usage (including in new user-created files) by enabling the Group Policy, “Prevent Excel from running XLM macros”, which is configurable via Group Policy Editor or registry key.
XLM is disabled by default in the September fork, version 16.0.14527.20000+
Current Channel builds 2110 or greater (first released in October)
Monthly Enterprise Channel builds 2110 or greater (first released in December)
Semi-Annual Enterprise Channel (Preview) builds 2201 or greater (we create this in January 2022, but it first ships in March 2022)
Semi-Annual Enterprise Channel builds 2201 or greater (will ship July 2022)
To learn more:
Restrict usage of Excel 4.0 (XLM) macros with new macro settings control - Microsoft Tech Community
Working with Excel 4.0 macros - Excel
Enable or disable macros in Office files - Office Support
Subscribe to our Excel Blog and join our Excel Community to stay connected with us and other Excel fans around the world.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.