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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-08T15:53:51+00:00

    Steve, I've found a way to run macros.

    Open regedit.msc (Registry Editor)

    Navigate to the app's security key:

    Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Security

    1. Create a new DWORD Value named BlockContentExecutionFromInternet
    2. Set the new BlockContentExecutionFromInternet value to 0
    3. Fully close and reopen the app
    4. To revert these changes, delete the registry value (BlockContentExecutionFromInternet) that was created
    5. Open cmd.exe (Command Prompt)
    6. Run the following command:

    REG ADD HKCU\SOFTWARE\Microsoft\Office\16.0\Excel\Security /v BlockContentExecutionFromInternet /t REG_DWORD /d 0

    I've been struggling with microsoft answers, tried everything suggested, my IT department were baffled... THIS WORKED!

    We've now missed the month end deadline and it's caused no end of issues, but I'm relieved it's working again now.

    Thanks so much

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-09-01T12:18:06+00:00

    Hi, for the solution that works for almost everyone, ie "re-map the network drive to the fileserver name", can you give me an example of how to do that for OneDrive folder?

    ie my normal OneDrive folder sits in "C:\Users\jonny\OneDrive\SomeFolder", how do I go about "re-map the network drive to the fileserver name"?

    thanks

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-06-13T11:34:05+00:00

    Dear ED20212021,

    It looks like the situation on your side is a bit different as you cannot find the Unblock checkbox when you go to the file’s property.

    We’d like to confirm what is the version and channel of your Excel application?

    As mentioned in the article, the change is released to Current Channel(Preview) version 2203 and Current Channel version 2205.

    ![](https://learn-attachment.microsoft.com/api/attachments/157cdd7f-2fe5-4916-8511-5ca23281ce74?platform=QnA

    At the same time, we’d like to confirm that does the issue appear when you open a specific XLSM file or different XLSM files?

    Thank you for your understanding and time.

    Sincerely,  

    Edwine | Microsoft Community Moderator

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-06-10T09:35:08+00:00

    Hi,

    I have the same issue, it started yesterday. I have a mapped network drive within my organization and I want to add it to trusted locations. Excel does not allow me to add an IP address, only a name of the server. This is also problematic. The macro is trusted and it does run on my personal harddrive, just not the mapped network location. Because I know what I open, I usually "enable all macros (not recommended)" and accept the risk.

    Guidance would be highly appreciated.

    Thanks,

    Ryno

    Was this answer helpful?

    0 comments