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!

One drive, another initiative from Microsoft. I deleted everything associated with OneDrive after Microsoft decided it was a good idea to hijack my file system and take over my documents folder. Disgraceful behaviour. If it weren't for my work using windows, I would scrap it entirely for an Open Source operating system. I agree. Microsoft are behaving like a pagan god! I'd love to switch everything to Open Source, like Ubuntu, but everything Excel that I use is macro-rich. From my stocktaking system to my accounting system (my business is pretty unique) I run somewhere over a hundred macros, some being many pages in length. The files have evolved since 2002. Just too much work to change over! But if there was a magic program that would recognise every macro command in Excel and magically convert ... LOL. In the meantime, I may have found a temporary solution to Microsoft blocking my macros: After an hour reading everything I could on the problem, I shut Excel down and reloaded. It seems to have worked!

Great. it's worked for me by changing the network drive from IP address to \fileserver name .

I am trying to open a spreadsheet from my accountancy firm that needs macros to update to the UK Revenue and Customs. I cannot work out how to unblock the macros. You help simply says select the appropriate options, but does not say what they are. This is hugely frustrating, and new.

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-19T01:28:35+00:00

One drive, another initiative from Microsoft. I deleted everything associated with OneDrive after Microsoft decided it was a good idea to hijack my file system and take over my documents folder. Disgraceful behaviour. If it weren't for my work using windows, I would scrap it entirely for an Open Source operating system.

I agree. Microsoft are behaving like a pagan god! I'd love to switch everything to Open Source, like Ubuntu, but everything Excel that I use is macro-rich. From my stocktaking system to my accounting system (my business is pretty unique) I run somewhere over a hundred macros, some being many pages in length. The files have evolved since 2002. Just too much work to change over! But if there was a magic program that would recognise every macro command in Excel and magically convert ... LOL.

In the meantime, I may have found a temporary solution to Microsoft blocking my macros: After an hour reading everything I could on the problem, I shut Excel down and reloaded. It seems to have worked!
Was this answer helpful?

0 comments No comments
Anonymous

2022-11-21T03:03:29+00:00

Great. it's worked for me by changing the network drive from IP address to \fileserver name .
Was this answer helpful?

0 comments No comments
Anonymous

2022-12-27T16:21:03+00:00

I am trying to open a spreadsheet from my accountancy firm that needs macros to update to the UK Revenue and Customs. I cannot work out how to unblock the macros. You help simply says select the appropriate options, but does not say what they are. This is hugely frustrating, and new.
Was this answer helpful?

0 comments No comments