Excel 4.0 (XLM) macros now restricted by default for protectiion Office

    Excel 4.0 (XLM) macros now restricted by default for protectiion

    Excel 4.0 (XLM) macros now restricted by default for protectiion

    Category: Office
    Posted: 20 Jan 2022

    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:


    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
    Brink's Avatar Posted By: Brink
    20 Jan 2022


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 07:57.
Find Us




Windows 10 Forums