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 think I've found the reason and solution. I went into the windows explorer to the file In the properties I marked the radiobox below and that's it. For some reason it blocks any file even youre self generated one when it comes through internet in the machine.

Hi Peter :-) I feel for you. At least I only had to figure out how the heck to use my own machine again. I've been through the process a number of times forgetting on each occasion how I resolved the issue (I'm about to turn 70 :-( ). The last time I eventually found that for me the answer was far simpler than it has obviously been for you. I discovered how to add trusted locations through Trust Centre settings. I rely on a system that uses thumb drives to duplicate my daily working files from the computer in case of fire. I simply add those thumb drive letters to Trusted Locations, and haven't had the issue since. Oh, I've certainly had other issues. Producing inexplicable issues is what Microsoft seems to be best at. The latest necessitated reviving an older stocktake file version and copy and pasting about 2,000 lines of data across. The problem had been that every time I tried to enter data into column G the cursor froze, the cell refused the entry and every other excell spreadsheet just showed a white blank screen. When I finally did get the cursor to move, the data would appear in every cell I went to except the one in column G. Its working now of course. Until the next issue. I understand your dying romance with Microsoft. If there was a practical competitor I would have defected years ago. Just too many very long macros to adjust in both an accounting program and a stock control program. All the best!

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 In 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 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 (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!)

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!)

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-06-08T15:11:32+00:00

I think I've found the reason and solution. I went into the windows explorer to the file

In the properties I marked the radiobox below and that's it. For some reason it blocks any file even youre self generated one when it comes through internet in the machine.
Was this answer helpful?

0 comments No comments
Anonymous

2023-04-19T02:59:39+00:00

Hi Peter :-)

I feel for you. At least I only had to figure out how the heck to use my own machine again.

I've been through the process a number of times forgetting on each occasion how I resolved the issue (I'm about to turn 70 :-( ). The last time I eventually found that for me the answer was far simpler than it has obviously been for you. I discovered how to add trusted locations through Trust Centre settings. I rely on a system that uses thumb drives to duplicate my daily working files from the computer in case of fire. I simply add those thumb drive letters to Trusted Locations, and haven't had the issue since. Oh, I've certainly had other issues. Producing inexplicable issues is what Microsoft seems to be best at. The latest necessitated reviving an older stocktake file version and copy and pasting about 2,000 lines of data across. The problem had been that every time I tried to enter data into column G the cursor froze, the cell refused the entry and every other excell spreadsheet just showed a white blank screen. When I finally did get the cursor to move, the data would appear in every cell I went to except the one in column G. Its working now of course. Until the next issue.

I understand your dying romance with Microsoft. If there was a practical competitor I would have defected years ago. Just too many very long macros to adjust in both an accounting program and a stock control program.

All the best!
Was this answer helpful?

0 comments No comments
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

In 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 No comments
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 No comments