Macros Blocked by Microsoft

[Andy Pilkington]

I am running Microsoft 365 and recently the macros on my spreadsheets have been blocked by Microsoft without asking and I can no longer properly use my spreadsheets. Does anyone know why this is and if there is a solution?
Thank you in anticipation. Andy

 

[MARK858]

The most common cause if you download a file or if you receive an email with a file containing macro's then Windows automatically blocks it (and has done since Windows 10)
Either
Right click the file, click properties and on the General tab near the bottom see if there is an Unblock checkbox, if there is then click the checkbox
or
Put the file in a trusted location (Developer tab, Macro Security, Trusted Locations).

If not the above then we could do with seeing a screenshot of the message it is giving you

 

[Andy Pilkington]

The most common cause if you download a file or if you receive an email with a file containing macro's then Windows automatically blocks it (and has done since Windows 10)
Either
Right click the file, click properties and on the General tab near the bottom see if there is an Unblock checkbox, if there is then click the checkbox
or
Put the file in a trusted location (Developer tab, Macro Security, Trusted Locations).

If not the above then we could do with seeing a screenshot of the message it is giving you

Hi Mark,

Thanks for your response. However, I don't download spreadsheets, the issue is with one of my own which has always performed flawlessly until this "block". Also, as I of course trust all my sheets, I have my macro settings in the Trust Centre set to "Enable VBA Macros".

I have uploaded the error message. Does this make the issue any clearer?

Thanks
Andy

 

[MARK858]

Can you post the code that you are trying to run please? and what module it is currently in

 

[Strithken]

Hi Mark,

Thanks for your response. However, I don't download spreadsheets, the issue is with one of my own which has always performed flawlessly until this "block". Also, as I of course trust all my sheets, I have my macro settings in the Trust Centre set to "Enable VBA Macros".

I have uploaded the error message. Does this make the issue any clearer?

Thanks
Andy

Try changing the workbook name. If that doesn’t work, please upload a screenshot of your Macro Settings from the Trust Center.