Microsoft has blocked macros from running

Anonymous
2022-06-08T03:54:07+00:00

Hello All,

you might know that " Microsoft has blocked Macros from running through internet" do we have any permanent solution on this?

I have tried the below solution which doesn't work.

  1. Save the file to a local hard drive, network share, or cloud share like OneDrive.
  2. Open Windows File Explorer and go to the folder where you saved the file.
  3. Right-click the file and choose Properties from the context menu.
  4. At the bottom of the General tab, you should see a section for Security. Select the Unblock checkbox and select OK.

Also, tried to enable Macros through Macros settings through Trust center but didn't work?

is there any permanent solution on this?

Thanks,

AMit

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2022-06-17T08:05:21+00:00

Hi,

I think I found a solution to my problem.

The solution is to re-map the network drive to the fileserver name first and then adding that mapped directory to the trusted locations in excel.

Mapped Location:

\fileserver\networkdirectory and not \[192.xxx.xxx.xxx]\networkdirectory

Hope it helps someone out there.

Regards,

Ryno

Was this answer helpful?

100+ people found this answer helpful.
0 comments

112 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2022-09-01T06:24:27+00:00

    Hi Nicholas, here is more information about how to unblock the macros from the web you trust:

    This change is to enhance the security and more details can be found in Helping users stay safe: Blocking internet macros by default in Office - Microsoft Tech Community.

    Thank you!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-09-01T06:08:55+00:00

    Hi Arpit,

    For end users, you can refer to A potentially dangerous macro has been blocked (microsoft.com) to find more information about how to unblock the macros you trust.

    And if you need to work with the administrators to unblock multiple files/locations in the organization, you can find more solutions in Macros from the internet are blocked by default in Office - Deploy Office | Microsoft Docs.

    Hope it helps.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-09-01T03:49:05+00:00

    Same here. Trying to run Access macros and this idiotic error suddenly popups up. I created the macros and so should be able to decide if they're trustworthy. My report-writing business runs on macros!

    Enabling VB module and changing security no longer works. God this company is way too in my life. I can't stand jerking around with the OS and Office. I don't have to deal with this endless **** from any other programs!

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  4. Anonymous
    2022-08-31T19:48:07+00:00

    I have been trying to find a solution to the same problem and this worked. Great. Thank you.

    Was this answer helpful?

    0 comments