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:
- Group Policy Path: User configuration > Administrative templates > Microsoft Excel 2016 > Excel Options > Security > Trust Center.
- Registry Key Path: Computer\HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\Office\16.0\excel\security
In addition, this policy setting can be managed with:
- Cloud policies may be deployed with the Office cloud policy service for policies in HKCU. Cloud policies apply to a user on any device accessing files in Office apps with their AAD account. Learn more about Office cloud policy service.
- ADMX policies may be deployed with Microsoft Endpoint Manager (MEM) for both HKCU and HKLM policies. These settings are written to the same place as Group Policy, but managed from the cloud in MEM. There are two methods to create and deploy policy configurations: Administrative templates or the settings catalog.
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.
Source: https://techcommunity.microsoft.com/...r/ba-p/3057905