Enable Macros With a Shared Workbook using Office 365

[Hardware Man]

As the title of this post suggests, I have a workbook with a number of macros that I'd like to share with a colleague at another location. I sent him a permission link so that he can access the workbook from my One Drive. The problem is, that the only way he can enable the macros is to save the workbook to his own machine (and then use the trust center to allow it). However, if he does that and then goes to save the file, he gets a prompt to save it to HIS One Drive, and can't save it to mine. Is there a solution to this?

 

[Micron]

Files downloaded from the cloud or web are often automatically blocked. Maybe see if that is the problem (right click on file, choose properties, look at General tab).
In this example, the file is blocked. Sorry, I can't recall exactly how restrictive that makes the file. IIRC you don't see this option for normal files.