Existing .xlsx file shared from OneDrive – how do I add macros to it?

I've just been on an hour-long chat with customer support, who didn't know anything about this. They sent me to this forum. Hope you can help.   I have an active Microsoft 365 subscription. I have ...