SECURITY RISK Microsoft has blocked macros rom running because the source of this file....

Hi,

Can you help?

I've been running this spreadsheet for many years and suddenly I have this error.

SECURITY RISK Microsoft has blocked macros rom running because the source of this file is untrusted.

I've had this before and gone into the options and clicked the box which said something like, 'allow macros'.

I am running Microsoft 365 and Excel is Version 2402 (Build 17328.20184 Click-to-run)

I didn't create this file and I'm not experienced in this field.

File attached.

Hello Robert,

That is more of just a warning than an error. MS introduced this some time ago to keep files safe (macro enabled files) when sharing/downloading and leaves it up to a User to determine if it can be trusted or is known to be trusted.
Before opening your file, right click on it and from the selection menu that appears, click on Properties then tick "Unblock" in the next menu that appears then click on "Apply" and finally "OK".
You should now be able to open your file as per usual.

I opened it without any problems doing so.

I hope that this helps.

Cheerio,
vcoolio.

Hi vcoolio,

Thank you for responding to my post.

Unfortunately, I have no "Unblock" check box.

Attachment 865020

Hello Robert,

I did exactly the same as Ali. No problems on my end.
Follow her instructions as well and it will work for you.

Cheerio,
vcoolio.

Hi Ali,

Wonderful, all works well and as it should, perfect result.

Thank you very much for your support.

Hi vcoolio,

Thank you.

You're welcome Robert. Glad we could help and thanks for the rep.

Cheerio,
vcoolio.

Hi Ali,

All done, thank you