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

Sorry Ryno but that answer requires expertise that I don't have. I'm not on a network so don't have a fileserver. Wouldn't have a clue about "remapping". I use macros all the time, some very long and buil/extended over many years. None involve the internet! I just want to stop Microsoft trespassing on my machine and making unauthorised changes!

I have the same exact problem. I cannot unblock my own coded macro !! It is a one drive file. There is no network administrator except for me, myself and I. This is a personal PC that no one else uses except for me. Now what?????

No security checkbox is shown. No effect on result. Location is already mapped as extended drive on system. Copying to base drive has no effect.

How do I access the assignment on macbook?

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

2022-11-19T00:52:13+00:00

Sorry Ryno but that answer requires expertise that I don't have. I'm not on a network so don't have a fileserver. Wouldn't have a clue about "remapping".

I use macros all the time, some very long and buil/extended over many years. None involve the internet!

I just want to stop Microsoft trespassing on my machine and making unauthorised changes!
Was this answer helpful?

0 comments No comments
Anonymous

2022-11-07T01:30:50+00:00

I have the same exact problem. I cannot unblock my own coded macro !! It is a one drive file. There is no network administrator except for me, myself and I. This is a personal PC that no one else uses except for me.

Now what?????
Was this answer helpful?

0 comments No comments
Anonymous

2022-11-05T20:33:11+00:00

No security checkbox is shown. No effect on result. Location is already mapped as extended drive on system. Copying to base drive has no effect.
Was this answer helpful?

0 comments No comments
Anonymous

2022-10-19T15:17:02+00:00

How do I access the assignment on macbook?
Was this answer helpful?

0 comments No comments