Programmatic access to Office VBA project in Office 365

[CRHAAG]

Hello everyone,

I have a workbook that I built in Excel 2013 which contains some VBA code requiring programmatic access. I sent the sheet to a user who has Office 365 along with instructions to allow programmatic access that I found at:
https://support.microsoft.com/en-us/help/282830/programmatic-access-to-office-vba-project-is-denied
He is telling me that these instructions do work in Office 365 and he is unable to figure it out. I don't see any specific instructions for allowing this in Office 365 and am wondering if somebody might have some experience with it. I do not use it myself, so am unable to investigate on my own machine. Any help would be greatly appreciated.

Thanks,

Chris

 

[Fluff]

With O365 Select File > Options > Trust Center > Trust Center settings > Macro settings > Check the box by "Trust access to the VBA Object model" > Ok > Ok

 

[Kyle123]

It’s possible he may not be able to, many IT departments restrict the access of this property (with good reason) through group policy. It’s one reason that writing code with code typically isn’t a good idea