MS Office macro settings should not affect the CM add-ins because they are COM/VSTO add-ins, not macros. Micro Focus' expectation is the organisation could disable all macros if they wish, and it should not prevent the CM Office add-ins from working.
What's more likely is an organisation may choose to implement hardening recommendations for MS Office such as those from ACSC (https://www.cyber.gov.au/acsc/view-all-content/publications/hardening-microsoft-365-office-2021-office-2019-and-office-2016), i.e. enabling group policy settings for MS Office such as "Disable Trust Bar Notification for unsigned application add-ins and block them" and "Require that application add-ins are signed by Trusted Publishers".
The CM Office add-ins are digitally signed, so if an organisation wishes to do this, they would need to add the Micro Focus signing certificate (the one used to sign all the CM Office add-in DLL's) to the Trusted Publishers store to allow the CM Office Add-in to load.