How To Enable "Microsoft has blocked macros from running untrusted source" Setting

[@jiejenn]

If you don't see the unblock option, it is most likely OneDrive is your default folder system. In that case, you will need to shut down OneDrive first.

[@victormanoury8101]

You are the best brother! Looked all over the internet to find out what was wrong, only to find it in this comment section. Thanks

[@rajkapse1720]

Sir how to do this in Mac OS please suggest

[@angelabokslag641]

Hi, it turns out that my OneDrive is off. But still can't run the macros. Please help. Thank you

[@gotcoke795]

How about if this is on an enterprise PC… not sure if I even have that option?

[@jiejenn]

@@gotcoke795 talk to your admin they will need to give you permission.

[@nitrork]

"We have determined that using our own software in the most rudimentary way possible is a security concern, so we've blocked it"
...Phenomenal work from Microsoft.

[@nurongame2118]

Thank you

[@PattyManatty]

Macros are a big security risk. Macros are a powerful tool that can allow arbitrary system access particularly if you run excel as a root user.
This is definitely a worthwhile thing to add severe protections around

[@eliopalombi]

@@PattyManatty that's true. But there is no reason to make it so impossible to disable them.

[@Solution88833]

Thank you so much, Jie. I have been trying to call Microsoft for a number of days, and they hopelessly could not help. Great Video.

[@RodUrdaneta-yy7si]

While waiting for MS support to call back, I researched youtube and this came up. Followed steps and worked. Thank you!

[@victorobado8017]

I,ve never been so happy to get a solution this easy....thank you.

[@goldensleeves]

What if the "unblock" option is not available in my "general" tab? I don't have the "security" section down there at the bottom to give me that option. Any thoughts? Thanks!

[@honestindian2106]

then you are not enabling it by admin account , you must have logged in by guest or employer account

[@TrentMRobertson]

@@honestindian2106 I'm an admin on my machine, and I don't see it either.

[@honestindian2106]

@@TrentMRobertson don't keep/open file from non local system like one drive, share drive, external hard drive, take it on your own system then check , this setting will be available

[@orra2529]

@@honestindian2106 Nope. Opened locally, with AD admin account. Option is not there.

[@jconci]

@@orra2529 I'm having same issue, hope someone finds a solution this has literally made some very important spreadsheets I made basically worthless.

[@glenespn]

i experience this issue, but when i go to Properties , I can't see the Security and Unblock, is there any other way to do this ?

[@SuMyat-j5u]

I have been fixing this issues for several days, now this video solved, thank you

[@sarahc.5202]

Thank you!! Quick and easy! You saved my work day!

[@biswaksenmishra7617]

Thanks a ton!!! Solved my issue. I was unable to enable macros despite making changes under 'Macro Settings'. But following one small step prior to that, as suggested in this video, helped my cause.

[@awaliendheasyafitrie6960]

The option to unblock under properties is not available for me, how do I get this option under properties?

[@DIMALRANDIKA]

I have the same issue, I can't find the option to unblock

[@Living4601]

Thank you for the quick explanation! I was having issues with an excel add-in file and this fixed it.

[@tsuigordon1108]

0:58 what if I had no "security" option at the bottom of the panel? Thanks!

[@Rose-dd9vx]

Thank you so much! I’ve been looking everywhere for a solution!

[@cafeteriaastoria5203]

at 1:01 in the window there is a security unblock. Mi excel does not show it. How can I fix this? (have excel 365)

[@jiejenn]

@@cafeteriaastoria5203 you probably have OneDrive set up as the default drive. You need to close OneDrive first.

[@davidcarrick4283]

How can I fix this as my default for my computer as a whole. this is useless if I have to do it for every file

[@jiejenn]

I don't think you can set it to default, at least there is no easy way at this point.

[@WestleyMonell]

Thank you!
Just in case anyone needs it, came across a gpedit (run as admin) solution for all files:
User Configuration > Administrative Templates > Windows Components > Attachment Manager
Change the Do not preserve zone information in file attachments setting to Enabled.
Save and exit.

[@TAUFIQKHAN]

it does not work for me :(
i used 365

[@JoeOrsak]

I have no security checkbox on the file. I'm downloading the file from Sharepoint using the "Open in Desktop App" setting. I have to use the file in this way because more than one person may use the file at a time. If I save the file locally on my desktop it opens with no macro issues. I can't open it that way though for the prior mentioned reasons.

[@Misscharmy12s]

Thank you Jie Jenn. ❤

[@tullowhill]

any idea what to do if the security option isn't visible at the bottom of the general tab in excel property settings?

[@richardpoole9678]

Cheers mate, works well. Commenting for the algorithm.

[@carmenhernandez5383]

Thank you! Thank you! you saved my homework night!

[@saifriyami4002]

simple and to the point. Thanks

[@Bitogt]

You're a life saver mate... Cheers

[@junipersprites2167]

Thank you! Very helpful for people like me who aren't tech-savvy.

[@chrisbegin5490]

Well done, thank you Jie!

[@medmalyani1883]

Thank yous freind jie

[@austinmeehan3522]

This worked for me. Thank you so much!

[@91laibasarfraz70]

after wasting days .I found this thankyouu

[@ekelvink]

Thank you so much for helping me out with this issue.

[@enriquenoriega2953]

Excellent, short and it works!

[@XLnCADMalayalam]

Thank you :)

[@shabrotherss]

Very helpful. Thanks dear

[@abhishekaggarwal9040]

Thank you so much. It resolved my issue.

[@ericcotton6042]

Cool quick and easy - thank you

[@pritamsarkar3924]

This is working man.... Thanks buddy..

[@AnupamaR-f8y]

Thank you so much. This is really helpful!

[@DemoNick87]

I don't have "Security" and "Unblock" checkbox

[@amitapattewar7952]

Same here

[@amitapattewar7952]

How to solve

[@venkateshs2600]

Same here please help

[@MarkCasquero]

yes same here. what to do if there is no Unblock section?

[@victormaiasouza5702]

Same

[@aswinnagarajan5411]

Bro Thanks a lot it was very useful. I got stuck and i dont know what to do. After seeing your video I was able to solve the issue.Once again Thank you so much.

[@omz96o]

I dont have the unblock option.. my problem is excel deletes all macros in the file once i open it, so i cant really run them when they are not there... how can i fix please?

[@briansmith-bo1ul]

Thanks!

[@jiejenn]

Glad the video help Brian.

[@RichardLimbe]

Thank you so much for this, I was stuck.

[@drunkandspill7815]

Thanks, man! it's really helpful

[@ReenaDelaCruz-e7i]

So helpful 🫶🏻

[@adityaweighing5470]

Excellent information

[@dane5171]

Great help. Thank you so much!

[@sanarazzaq6792]

Thank you for this video. Definitely helped me today

[@azhadshamim3122]

Thank you so from Doha
I was facing this issue since 2 days and thankfully its solved ❤

[@yashwanthks9711]

Thank you very much Jie!

[@gijspersonal7528]

Thanks bro, you saved me alot of time with this video❤

[@Stoneyhilly]

jeez thanks a million short and to the point just great.

[@nunocorreia5570]

Thanks for your tutorial... simple and efficient 👍

[@x-files5551]

I don't have this setting on my files because I created my own macro. Now Microsoft will not let me run my own macro!! What can I do now?

[@anilpatni893]

Thanks bro it's really helpful for me

[@tUBEROCKErPriyankar]

You saved my life bro.

[@carlyhope]

Thank you. This was really helpful and save me a lot of work.

[@quickbooksbasic8698]

it doesn't show the "security" part in the General tab of Properties on my computer, how to make it visible

[@manishprajapati3621]

Thank you for this video today I have use the video

[@kamaunjuguna6913]

So easy. Thank you very much for your help.

[@Ahmedali-bx9ng]

Thanks for your support
Really appreciate 🙏🏻

[@ProffKnowledge]

Thankyou so much. It works for me.

[@teguhsasmita9019]

Thank you brother, it's really helps

[@jeisrahelalenaung1170]

Thankyou for the idea.. Love it from Indonesia..

[@dshahadat]

Thank a lot dear brother. Its really helpful video.

[@HayleySaunders-k8k]

Thank you so much! solved my issue instantly.

[@santhoshkumard3606]

Worked, thanks!

[@sulanat]

You helped much. Thank you very much.

[@attorneytee115]

Thanks for making this useful vid. You have saved my life, bro!

[@mrdini1]

THANKS ALOT BRO..GREAT TUTORIAL😊

[@AESSOIL]

I don't see an unblock under the properties on the excel spreadsheet I am using.

[@ChandruA-n2w]

Thanks .. problem solved 👍

[@cadenjohnson4844]

My "properties" does not look like this at all. It doesn't have those check boxes. Any ideas?

[@melishat9196]

The issue has resolved. Thank you. 🙂

[@sabrinahilyati3164]

Hi. I've already done the way u taught and it did works.. However when I'm try to open again the file back I faced the same issued again which is I can't view my macros file and all....any idea how??

[@jiejenn]

Office has multiple layers of securities to run macros, make sure you have enable every single one of them.

[@ramanaiahmavuluri3597]

Thank you!. Much helpful.

[@syedshadabbas5991]

option not coming since file is on sharing server - how to go about it without copying it to local drive which is against policey

[@bishalsamal9719]

Thank you so much for your information it's very helpful for me...

[@louisechivwara]

This is a great video! But how do I do this on a macbook? Could you make a video for macbooks?

[@jiejenn]

Hi. Unfortunately I don't own a Mac.

[@antoinetteatieno4364]

Very helpful!

[@jishnuviswanath3565]

Thanks:) the video is very useful!

[@NicolasKeesler]

I have that problem but I dont have the Security message, what can i do?

[@yams900]

Good work ! It solved my problem

[@manu-j1347]

Thankyou so much sir for information it is useful 😍😍❤️

[@denninuariskm]

Thabks for your information .. very helpfully

[@EshwarReddy-md6qt]

Thanks Jie

[@navtechnologies8400]

Thank you! you made my day 🙂

[@marksanders768]

This is also true of files NOT downloaded from the Internet. This happens to all my files, now - none of which have ever been anywhere near the Internet.

[@ralphlim9836]

Great Tutorial Vid... Well informative, it makes help to us solve this issue. Thanks :D

[@SecretHover]

thanks

[@zypherxivgaming9515]

Nice trick man thanks.

[@ibbadmalik]

Is there any solution to make it default. I dont want to unlock macros again and again each time i download the new file?

[@jiejenn]

Not that I know of.

[@OStefanoBraga]

you are a angel, thanks!

[@lunadika7861]

it's worked! thank you so much ❤️

[@snsassociates3854]

Thank You Sir, Your save my time, Thank you

[@apolloafrobeats]

Thank you Sir.

[@moominjuniee]

Thank you for this useful vid :))

[@kannanmajeev1767]

THANKS IT HELPED

[@shobhasalescompany9476]

Thanks !! Its useful !!

[@stylewithcss]

thanks for uploading this video.

[@eismscience]

Thank you!!

[@riteshjha820]

YOU ARE LOVABLE SIR...THANKU SO MUCH SIR..