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. Save the file to a local hard drive, network share, or cloud share like OneDrive. Open Windows File Explorer and go to the folder where you saved the file. Right-click the file and choose Properties from the context menu. 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

I found this in another thread here in MS Community. Glad that it worked for you.

Worked like a charm! (I did it in the Word folder (in the registry) instead of Excel because I am running code on a Word doc - from a private cloudshare.) Anyway, when I open a doc, it still blocks macros but now gives me the choice to make it a trusted document (again). Brilliant! THANK YOU!!!!!! :-) :-) :-)

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 Create a new DWORD Value named BlockContentExecutionFromInternet Set the new BlockContentExecutionFromInternet value to 0 Fully close and reopen the app To revert these changes, delete the registry value (BlockContentExecutionFromInternet) that was created Open cmd.exe (Command Prompt) Run the following command: REG ADD HKCU\SOFTWARE\Microsoft\Office\16.0\Excel\Security /v BlockContentExecutionFromInternet /t REG_DWORD /d 0

I am having the same issue: I created a personal finance sheet on our local machine using my wife's local login Logged into the machine as her, when I open the file, I get a macro warning and can easily enable macros The document is stored on a OneDrive folder that we both share (she owns the share) When I switch to my login, I get the red SECURITY RISK message and cannot trust the document Trusted locations doesn't work - I have "Trusted" that folder, it's parent, it's grandparent, checked "include all subfolders" -- NOTHING WORKS Opening properties doesn't work - there is no check/uncheck box to trust the document Adding a certificate isn't an option as I'm not a corporation and can't generate a certificate/signature None of the help files, forum postings or any other microsoft content helps AT ALL. It is unbelievable that Microsoft wouldn't simply allow you to mark a specific document as TRUSTED. That would fix this problem. I read a lot of forum posts here about mapping network drives - that's not applicable here. I simply want every single document in a specific OneDrive folder to be trusted - but that basic functionality DOES NOT WORK. Please respond with a solution that actually works. Microsoft® Excel® for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit

Microsoft has blocked macros from running

Anonymous

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.

Save the file to a local hard drive, network share, or cloud share like OneDrive.
Open Windows File Explorer and go to the folder where you saved the file.
Right-click the file and choose Properties from the context menu.
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

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

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

0 comments

112 additional answers

Anonymous

2023-01-05T23:43:59+00:00

I found this in another thread here in MS Community.
Glad that it worked for you.
Was this answer helpful?

0 comments No comments
Anonymous

2023-01-05T22:12:26+00:00

Worked like a charm!

(I did it in the Word folder (in the registry) instead of Excel because I am running code on a Word doc - from a private cloudshare.)

Anyway, when I open a doc, it still blocks macros but now gives me the choice to make it a trusted document (again).

Brilliant! THANK YOU!!!!!! :-) :-) :-)
Was this answer helpful?

0 comments No comments
Anonymous

2023-01-04T22:37:55+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
Was this answer helpful?

4 people found this answer helpful.

0 comments No comments
Anonymous

2022-12-31T05:44:13+00:00
I am having the same issue:
- I created a personal finance sheet on our local machine using my wife's local login
- Logged into the machine as her, when I open the file, I get a macro warning and can easily enable macros
- The document is stored on a OneDrive folder that we both share (she owns the share)
- When I switch to my login, I get the red SECURITY RISK message and cannot trust the document
- Trusted locations doesn't work - I have "Trusted" that folder, it's parent, it's grandparent, checked "include all subfolders" -- NOTHING WORKS
- Opening properties doesn't work - there is no check/uncheck box to trust the document
- Adding a certificate isn't an option as I'm not a corporation and can't generate a certificate/signature
- None of the help files, forum postings or any other microsoft content helps AT ALL.
- It is unbelievable that Microsoft wouldn't simply allow you to mark a specific document as TRUSTED. That would fix this problem.
I read a lot of forum posts here about mapping network drives - that's not applicable here.

I simply want every single document in a specific OneDrive folder to be trusted - but that basic functionality DOES NOT WORK.

Please respond with a solution that actually works.

Microsoft® Excel® for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit
Was this answer helpful?

0 comments No comments