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

Рет қаралды 524,017

2 жыл бұрын

Microsoft Office has rolled out a new security check to disable on default when you download a macro enabled file from a 3rd party source. In this tutorial, I will share the steps how to re-enable macro settings for those files.
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
📘 Facebook Page → / madeinpython
📘 More tutorial videos on my website → LearnDataAnalysis.org
👩‍💻 Follow me on Linked: / jiejenn
✉️ Business Inquiring: KZfaq@LearnDataAnalysis.org

Пікірлер: 304

@jiejenn 5 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

Sir how to do this in Mac OS please suggest

@angelabokslag641 2 ай бұрын

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 4 ай бұрын

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 2 ай бұрын

@@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 2 ай бұрын

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

@Living4601 6 ай бұрын

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

@Rose-dd9vx 8 ай бұрын

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

@ralphlim9836 Жыл бұрын

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

@attorneytee115 Жыл бұрын

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

@carlyhope Жыл бұрын

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

@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.

@gijspersonal7528 Жыл бұрын

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

@nunocorreia5570 11 ай бұрын

Thanks for your tutorial... simple and efficient 👍

@kamelamiller Жыл бұрын

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

@sanarazzaq6792 Жыл бұрын

Thank you for this video. Definitely helped me today

@navjotbrar4588 6 ай бұрын

thank you so much this vedio is very helpful for me 🙂😇

@ericcotton6042 Жыл бұрын

Cool quick and easy - thank you

@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 ?

@AnupamaR-f8y Ай бұрын

Thank you so much. This is really helpful!

@dane5171 3 ай бұрын

Great help. Thank you so much!

@santhoshkumard3606 Ай бұрын

Worked, thanks!

@austinmeehan3522 9 ай бұрын

This worked for me. Thank you so much!

@kamaunjuguna6913 Жыл бұрын

So easy. Thank you very much for your help.

@carmenhernandez5383 Жыл бұрын

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

@RichardLimbe Жыл бұрын

Thank you so much for this, I was stuck.

@manu-j1347 Жыл бұрын

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

@drunkandspill7815 Жыл бұрын

Thanks, man! it's really helpful

@tullowhill 5 ай бұрын

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

@azhadshamim3122 5 ай бұрын

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

@emenikekelvin9706 3 ай бұрын

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

@Ahmedali-bx9ng Жыл бұрын

Thanks for your support Really appreciate 🙏🏻

@junipersprites2167 Жыл бұрын

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

@enriquenoriega2953 Жыл бұрын

Excellent, short and it works!

@richardpoole9678 8 ай бұрын

Cheers mate, works well. Commenting for the algorithm.

@Misscharmy12s 11 ай бұрын

Thank you Jie Jenn. ❤

@bishalsamal9719 10 ай бұрын

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

@abhishekaggarwal9040 10 ай бұрын

Thank you so much. It resolved my issue.

@user-hc8ly3fn7j Жыл бұрын

Thank you so much! solved my issue instantly.

@dshahadat Жыл бұрын

Thank a lot dear brother. Its really helpful video.

@JoeOrsak 7 ай бұрын

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.

@jishnuviswanath3565 11 ай бұрын

Thanks:) the video is very useful!

@chrisbegin5490 Жыл бұрын

Well done, thank you Jie!

@medmalyani1883 Жыл бұрын

Thank yous freind jie

@JustWalker9 Жыл бұрын

Thank you! Very helpful. 👍👍

@denninuariskm 2 жыл бұрын

Thabks for your information .. very helpfully

@mpel988 Жыл бұрын

If the file is on onedrive or other cloud it does not show the security option in the proporties. You have to drag it to a folder on your computer first and after unblocking you can put it back.

@Sob3r777 Жыл бұрын

This does not work when you are not the main host of the onedrive location. For example try to share the file the client can not unblock because the option does not exist for clients...

@tmike200687 11 ай бұрын

This worked for me. Thank you.

@VS-ed8od 11 ай бұрын

same problem for me, no checkbox. if file is is other folder i can edit it but on copying to onedrive folder macro is disabled!!! any solution welcome..thanks in advance

@prjk4531 7 ай бұрын

@@VS-ed8od I still have the same issue

@mimocrocodile5069 4 ай бұрын

But I need this file in the same location. Can I do something with shared files?

@lunadika7861 Жыл бұрын

it's worked! thank you so much ❤️

@yashwanthks9711 Жыл бұрын

Thank you very much Jie!

@teguhsasmita9019 Жыл бұрын

Thank you brother, it's really helps

@tianohmusic8259 Жыл бұрын

Thanks you so much ..I made it through this bro …bravooooooooo

@sulanat Жыл бұрын

You helped much. Thank you very much.

@mrdini1 Жыл бұрын

THANKS ALOT BRO..GREAT TUTORIAL😊

@anilpatni893 6 ай бұрын

Thanks bro it's really helpful for me

@ProffKnowledge Жыл бұрын

Thankyou so much. It works for me.

@shabrotherss Жыл бұрын

Very helpful. Thanks dear

@saifriyami4002 5 ай бұрын

simple and to the point. Thanks

@pritamsarkar3924 Жыл бұрын

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

@muralimv2162 3 ай бұрын

Love you broo❤it works

@Bitogt Ай бұрын

You're a life saver mate... Cheers

@injuntaeil Жыл бұрын

Thank you for this useful vid :))

@selfloverswork 6 ай бұрын

this was helpful

@stefanobraga5718 4 ай бұрын

you are a angel, thanks!

@YouthinkImpact 8 ай бұрын

Thankyou so much. It worked😂!

@ravinderkhandelwal3363 Ай бұрын

Thank you sir ☺️🙏

@Fshhady Жыл бұрын

well done. thank you very much :)

@ramanaiahmavuluri3597 Жыл бұрын

Thank you!. Much helpful.

@hoangtuga1 2 жыл бұрын

It works, thank you very much!

@ReenaDelaCruz-e7i 26 күн бұрын

So helpful 🫶🏻

@Muralidharachar 7 ай бұрын

Thank you very much really helpful this video

@RhymeePlaylist 20 күн бұрын

Thank you so much ❤

@abigailsato8160 9 ай бұрын

Thank you so much. Big help

@melishat9196 Жыл бұрын

The issue has resolved. Thank you. 🙂

@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?

@navtechnologies8400 Жыл бұрын

Thank you! you made my day 🙂

@EshwarReddy-md6qt 4 ай бұрын

Thanks Jie

@engineerraufkhanwazir8253 9 ай бұрын

Thank you again

@snsassociates3854 Жыл бұрын

Thank You Sir, Your save my time, Thank you

@ake150cc8 Жыл бұрын

Thank You, It's Solved my problem

@user-ny6hd1db3v 18 күн бұрын

Thanks .. problem solved 👍

@XLnCADMalayalam Жыл бұрын

Thank you :)

@apolloafrobeats Жыл бұрын

Thank you Sir.

@user-po8tq5wo8q 6 ай бұрын

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

@yams900 Жыл бұрын

Good work ! It solved my problem

@ronhk 17 күн бұрын

Thanks bro!

@inevitable2900 8 ай бұрын

thank you, you are the best.

@maliheshahrabi7910 Жыл бұрын

thanks alot it was helpfull I really appreciate

@GarryChahalOFFICIAL Жыл бұрын

Thank you so much

@abeerabdelaziz-oo6up 11 ай бұрын

Thank you Very much

@franky350 Жыл бұрын

thank you. fast and good help

@septiansuharyadi9248 9 ай бұрын

Thank you, its work...

@shobhasalescompany9476 Жыл бұрын

Thanks !! Its useful !!

@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

@darianliyis730 Жыл бұрын

thank you so much, it works 👏👏

@91laibasarfraz70 5 ай бұрын

after wasting days .I found this thankyouu

@mohammedadilsadiki682 Жыл бұрын

it works, thanks for your effort

@behrad_ghasemii_nejad 9 ай бұрын

Thank you so much 🥰, very good

@user-td7ug9wl1u 7 ай бұрын

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

@engineerraufkhanwazir8253 10 ай бұрын

Thank you sir

@tsuigordon1108 10 ай бұрын

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

@saravanaco2974 9 ай бұрын

Thank you for ur Post

@behrad_ghasemii_nejad 9 ай бұрын

Very good, thank you❤️

@allingtonticharwa6367 Жыл бұрын

Awesome, Thank you.