Hi @Anonymous ,
Thank you for your patience throughout this issue.
I checked this internally and to authenticate the macros with Azure AD you can either digitally sign the macros or do certification-based authentication with Azure AD and Azure Key Vault.
Digital signatures can be used to ensure that the macros are from a trusted source, and no one tampered with the data.
Certification-based authentication involves obtaining a certificate from Azure Key Vault, which can then be used to authenticate the user and the macros. This approach provides strong security and can be used where the macros need to access sensitive data.
Hope this will help.
Thanks,
Shweta
Please remember to "Accept Answer" if answer helped you.