I have a spreadsheet containing a simple macro stored on my onedrive which i share with colleagues. I can open the s/sheet fine but when my colleagues do so excel give the "microsoft has blocked macros from running because the source of this file is untrusted".

I've checked all the trust centre settings and the internet security options which all appear to be as they should but with no luck. Microsoft support were of little help.

Anybody have any ideas? If you need more information just let me know.

Many thanks in advance for your assistance if you're able to help.