This policy setting controls whether macros can run in an Office 365 ProPlus application that is opened programmatically by another application. If this policy setting is enabled, the user can choose from three options for controlling macro behavior in Excel, PowerPoint, and Word when the application is opened programmatically: - Disable macros by default - all macros are disabled in the programmatically opened application. - Macros enabled (default) - macros can run in the programmatically opened application. This option enforces the default configuration in Excel, PowerPoint, and Word. - User application macro security level - macro functionality is determined by the setting in the 'Macro Settings' section of the Trust Center. If this policy setting is disabled or not configured, when a separate program is used to launch Microsoft Excel, PowerPoint, or Word programmatically, any macros can run in the programmatically opened application without being blocked.
Set the policy value for User Configuration >> Administrative Templates >> Microsoft Office 2016 >> Security Settings 'Automation Security' to 'Enabled (Use application macro security level)'.