macros blocked but all security settings appear to be correct

[IMPOSSIBLE7925]

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.

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Microsoft blocking macros but trust centre settings are apparently ok

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...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Also, please note that on the internet ALL CAPS = SHOUTING!

 

[IMPOSSIBLE7925]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Microsoft blocking macros but trust centre settings are apparently ok

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...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Also, please note that on the internet ALL CAPS = SHOUTING!

Hi RoryA, your comments are well noted! I prefer caps because it's easier on my eyes but take your hint in the good manner in which it was meant.