Excel 365/Excel One Drive run macro

Hi, I've created an Excel workbook with VBA. 

I've uploaded  this to One Drive and cannot now run the VBA. I've googled for an answer an am unclear on the next steps...can macros not be run within One Drive, or do they need to be made into eg trusted documents?...(and if so, how do i do this?)

(Note: as this workbook will contain a data connection to a partner site Zapier, who are creating the connection of us, say this workbook needs to live on the One Drive account.

Thanks

Many thanks Andy