Here’s a script I wrote that you can run to check the operation of Office macro’s on a device:
https://github.com/directorcia/Office365/blob/master/office-macro-get.ps1
For the script to execute you’ll need to run it as an administrator and have the Microsoft Graph module installed so the tenant wide addins can be checked.