Macro getting blocked and raising Security Concern on MS Excel office 365

Question

In Office 365 MS Excel is blocking Macros for files saved on Network because of recent changes done by Microsoft. Have referred this article https://learn.microsoft.com/en-us/DeployOffice/security/internet-macros-blocked#vba-macro-notification-settings but nothing has worked.

If I save file on local disc of computer then all macros are working.

Also, in the above article, it is written that by right clicking file , through properties we can unblock. However, this option is also not visible for the same file.

Kindly advice at earliest.

Answer 1

Hi, @Vishal Mulchandani
Welcome to the Q&A forum.
Microsoft blocked VBA macros by default for Word, Excel, PowerPoint, Visio and Access in Office 365 from April. To enable these macros, you need to save the file to a local hard drive, network drive, or cloud storage service such as OneDrive, and then manually unblock the file.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hello @Ceasar Chen_MSFT

Thank you for your reply.

Actually, I have tried the same but there is no option of Unblock when we right click on file.

Is there any other option to allow macro/unblock the same.?

Thanks
Vishal