WTF is going on? I can't access macros on my home PC

[Johnny C]

The trust centre has changed. Fine. But I have a ton of macros on my PERSONAL.XLSB and macros in personal files. I've eventually managed to enable PERSONAL.XLSB macros (which are run from the QAT) but there's a file which updates personal income which has a macro, and it just flags up

A potentially dangerous macro has been blocked​

every time. I've turned every Trust setting I can off (home goal Microsoft, you have to turn all settings off) and gone onto the file right click properties and there's no Unblock option.

 

[Georgiboy]

If you right click on the file and go to properties, they added a checkbox for you to trust the document. This needs to be checked - then the macros will work. I think it may be at the bottom of the 'General' tab on the document properties.

It seems to happen when a file has come from a different network than your current, i.e. sending spreadsheets from work to home via email.

Are you running 365?

 

[Johnny C]

That's the problem, I don't get that option

 

[daverunt]

I have never tried this but have a look here:
See if - Removing the ZoneId value helps.

Macros from the internet are blocked by default in Office - Deploy Office

Provides guidance for admins about how Office blocks macros in files from the internet.

learn.microsoft.com

There's also a link to the Readiness Toolkit...???

 

[Johnny C]

I presume in CMD but it doesn't work. I managed to add the folder for the macro to trusted sites and it worked.
They fixed the bypass, xlsb files were exempt from the macro settings but now (sadly) they fixed it.