New Security Settings Blocking Macros

[sparky2205]

This topic has already been discussed here:

Excel Security Settings not letting Macros Run?

I'm not sure what happened or what my security settings need to be anymore. I had a workbook that I was rolling into a new year, all I did was saved the old workbook with a new name. When I try to run the macros I get a "Security Risk" warning and all my macros are blocked. When I view...

www.mrexcel.com

I'm starting a new thread because the previous one is old and I have a further question.
From my searches I understand that Microsoft implemented these new security changes last year.
This is the first time I have seen an issue with them.
I have a user who is getting the dreaded:

But here's the interesting bit; he emailed me the file to check it out and I don't have the same issue. I just get the usual Enable Macros message.
So I opened the file, closed it and emailed it back to the user and now he can open it without getting the Security Risk message.

Anyone any thoughts on why this would happen?
I'm concerned I'm about to get a deluge of similar calls.

The Trusted Location option isn't an option as I have a lot of files which can be at various locations.
The option of Unblocking the file under Properties also isn't an option as there is no Unblock option in the File Properties > General tab.

 

[jkpieterse]

How did the user receive the file in question and where did he save it? Perhaps the message was sent from outside of your organisation's domain?

 

[sparky2205]

The file was received via email from a customer. So yes, it would have been outside of our domain. And I can see where the new security rules would kick in.
An when I sent it back to the user via email it would be within our domain. This would also explain why the users colleague could also open the file without issue.
But are we really saying that without any intervention a blocked file can simply be unblocked by resending it within a domain?

 

[sparky2205]

How did the user receive the file in question and where did he save it? Perhaps the message was sent from outside of your organisation's domain?

It would appear I've answered my own question. And the answer is yes.
I got the user to forward the customer's email to himself and the attached file, which displays the Security Risk message when opened directly from the customer's email, now opens without issue. i.e. The Security Risk message doesn't appear. The Enable Macros button can be pressed as normal and the macros are enabled.
Is this really a security improvement or just an inconvenience?

@jkpieterse thanks for pointing me in the right direction.

 

[jkpieterse]

Many will see this as an inconvenience, but due to the many infested Office files with malicious code being sent around in the past years Microsoft had to do something. I'm not to happy with it, but I guess this is what we'll have to put up with.

 

[MARK858]

implemented these new security changes last year

Started in Windows10 for files containing macros downloaded or sent via email