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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2023-04-18T17:36:36+00:00

    This reminds me of when Microsoft decided that as administrator on your own machine, you can't write to C drive without jumping through major hurdles! Jeez, doesn't anyone at Microsoft beta test code anymore?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-04-18T17:39:06+00:00

    Why doesn't Microsoft enable this ONLY IF YOU HAVE DEVELOPER TAB HIDDEN? If developer tab is unhidden, then trust us to have some measure of common sense and to decide for ourselves which network shares to trust!!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-04-18T17:43:40+00:00

    Yeah, that little message that asked me if I was "looking for your Documents folder?" thoroughly ticked me off! (And I am a diehard Microsoft fan!)

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-04-18T17:48:50+00:00

    Here's the solution from a few pages back. Nothing else worked for me until I did this. Worked like magic!

    Daniel Belini Matos

    Replied on January 4, 2023Report abuse

    ReplyIn reply to Steve Ciccarelli's post on December 31, 2022 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

    (Again, Microsoft, if developer tab is unhidden, then assume we have a small measure of common sense and make this optional - without having to resort to a registry tweak!)

    Was this answer helpful?

    0 comments