Excel - Security Risk Microsoft Has Blocked Macros From Running - Episode 2485

[@excelisfun]

This makes all files for my Highline classes which my student and I download much more difficult to use... But thanks for the hot tip, though!!!! The IT department at Highline had to change the networking parameters so that we all could use the files without having to right-click each file...

[@MrXL]

Great point! There are a series of hoops that you can jump through to prevent dealing with each file. Those are detailed when you click Learn More in the pink bar. Having read those, I opted for right-clicking each file.

[@wirechair]

Hi don’t mind me, I just wanted to say you guys are both amazing and through the internet you have helped me in my analytical development more than you will ever know. I will never be as smart as you guys and be able to follow your more complex formulas but the light I can see from the supernovae of your collective intellects have guided me further than I thought I could ever achieve! Although I have many of both your books, thank you guys for also having a heart and also sharing your knowledge for free. Thank you.

[@excelisfun]

@@wirechair Yes!!!!! I am so glad to help you, wirechair. Mr Excel is the guy who inspired me to make videos many years ago!!! Mr Excel is my #1 Excel guy : ) BTW, I am like you, wirechair, not so smart, but always working hard ; )

[@MrXL]

@@wirechair Thanks. It is great to hear this.

[@ebrahimalfardan8823]

How about one drive? I believe this happens to competitors cloud storage only

[@wirechair]

I wondered why I suddenly wasn’t able to use my little copy paste macro and thought it was just my pc being extra fussy. Thank you for the news and work around sir!

[@ganeshs1360]

i was facing this issue for a long time. had enabled all the trust settings and this was still occurring, thank you for making this video.

[@Huff-Robertson]

Am I the only one that doesn't have that feature on their properties? The properties on mine stop at attributes and there's nothing below it.

[@markcasquero7588]

me too! I don't understand why. How to solve it without this

[@goldensleeves]

When I right click on the file, my "general" tab does not have that whole "security" section with the option to check the "unblock" box. Why is that and what would my other option be? Thanks so much in advance!

[@shoestringlean7163]

That option is not available in the Properties Menu for me. I do use Dropbox, but this is a self authored workbook. I've unlocked everything in the trust center as well. I suddenly started getting this red macro warning this week after using this workbook for 10 years. Any Ideas?

[@enriquesada4415]

Thanks for the video. If the unblock checkbox does not appear, check if any other files are referenced, in my case it was a .xlam file, that's the one that had the unblock checkbox.

[@oddarnek]

In windows 11 this option is not available. But I found a workaround, Right Click --> Properties --> Details --> At the bottom, press the . A new popup appears named Remove Properties. I chose the first option, Create a copy with all possible properties removed. This creates a copy of the file with the macros working, but all properties removed, creator and dates etc.

[@markcasquero7588]

life saver thanks!

[@mss627]

What if the security option does not show up?

[@RenierWessels]

Thanks for sharing Bill.

[@mattschoular8844]

Thanks Mr.Excel

[@beznick6425]

What if the file is not accessible through explorer? I have excel file embedded in a SolidWorks part file. Says macros are blocked, because source of the file is not trusted (Im the source). Any idea, please?

[@MrXL]

Figure out where the workbook is being generated and make that a trusted location. I had the same problem with a program that would generate a Word doc and then run a macro in the newly created word doc. I figured out that the word doc was a sub folder of a certain path and added the parent path as a trusted location. Problem solved.

[@lonelyislander8760]

i don't have that unblock option.

[@MrXL]

See if you can set up a Trusted Location. Details: kzbin.info/www/bejne/j2mmgH9rpruVg5Y

[@chrism9037]

Thanks Mr Excel

[@theyaudcast4696]

you just saved my life, thank you

[@schoanahmed6328]

You save my life man, take Love with respect 💕🥰

[@gordonclarke9269]

Here in the UK just had MS 365 sub renewed. Since yesterday I cannot run my personal macros if the workbook is sent from i.e. the web or via email. Clicking on Properties > Security as directed, there is no sign of the 'Unblock' box that ccould be checked so I am left not being able to use excel files not on my local drive(?) Tried Options > Trust Centre > Macros > Enable (not recoommended) to no avail.

[@MrXL]

I’ve seen this. The only option is to set up a trusted folder and save the workbook there. There are other replies to comments here with a link to a video about SmartRoster that shows how to set this up.

[@mohammadrafiq6147]

Most of this option might seen security option uncheck box block

[@devyanirathod7631]

Hey Mr. Excel! I wanted to know if there's any way to remove a slicer option from the slicer displayed on a dashboard (which holds data in it, I just don't want it to be shown as an option on the slicer). So far, haven't found anything helpful. Love your work, thank you for sharing such amazing videos! You're an inspiration!

[@MrXL]

I can’t think of anything.

[@rowie4life]

But what do you do when the Unblock option isn't there?

[@MrXL]

Try a trusted location as described here: kzbin.info/www/bejne/j2mmgH9rpruVg5Y

[@mustaphaelbanak.9014]

Thank you so much

[@prashantrawat6738]

When I enable content all workbooks disappear.

[@garylewis4690]

Hey Mr Excel. I love watching yours & Excel is fun’s videos, you really inspired me to get interested in excel. One thing I would like to ask. Why do you always use XLSM for workbooks with Macros when you get all the same functionality by using XlSB? From experience XLSB only uses circa 60% of the memory & is generally much faster. Is there some limitations to XLSB that I’m not aware of or does it just come down to personal preference? All the very best, Gary.

[@MrXL]

I liked the ability to crack open the XLSM after renaming to .zip. It helped to discover the 17 digits of precision bug. It recently helped with counting images in Word files. So it was useful three times over 15 years. Probably not a legitimate reason in the long run.

[@wayneedmondson1065]

Thanks for the tip! Thumbs up!!

[@nhatminh1485]

I right click on the file, choose properties, but I don't see unblocked

[@bordignonjunior]

THANK YOU !

[@sudeepsaru1110]

Thanks A lot Sir ! It really helped me !

[@timsampson2941]

Why do I never see what you see on the properties page even though macros are being blocked in my file? My files are stored in our company's OneDrive and I can't see any way to allow macros.

[@MrXL]

I've asked my contacts at Microsoft about workbooks stored in OneDrive. No response yet. In a new video, I show how to set up a trusted location to get the macros to run: kzbin.info/www/bejne/j2mmgH9rpruVg5Y

[@mohamedabbad5839]

THANK YOU

[@Shadow-mx4es]

thanks a lot

[@josephkimote661]

👍 Good things here, learning alot. I have created a vba userform with autocomplete drop-down combobox search creteria but when I search based on a number or date column it is not able to search. It only searches text-data type columns. How can I modify the code to search for numbers, date and text or combination of any of the data types. Your response will be highly appreciated. Thanks in advance

[@MrXL]

Finding dates with VBA is tricky. See Response #4 in this thread: www.mrexcel.com/board/threads/ctrl-f-cant-find-value-in-date-format-eomonth-formula-used.1200623/

[@minhluannguyen1499]

i love you!!!!

[@Edoble25]

How to fix this issue on a MAC OS?

[@akhilkrishnan7362]

Thank you ❤❤❤❤

[@Milhouse77BS]

Lol. “Mark of the web”

[@DavidTorres-nm6sx]

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

[@MrXL]

I've had this happen sometimes. The solution then is to trust the folder that holds the macro. File, Options, Trust Center, Trust Center Settings (on the right), Trusted Locations (on the left), Add New Location (bottom right).

[@sweetbow4111]

When I go to properties -> general that option of unblocking does not display. Is there another place where it is located?

[@andersonteixeira7214]

I've found the same problem! There is no option of unblocking...

[@MrXL]

Try using a Trusted Location as shown in this new video: kzbin.info/www/bejne/j2mmgH9rpruVg5Y

[@amylauersdorf288]

@@MrXL It won't allow me to add the trusted location to my personal PC. The file is from a PC on my work's network. I tried to add that IP and specific folder's location, but that's not working either

[@Firas--TRD]

🔥🔥🔥🔥

[@johnbutler2750]

Like the video, dislike the change.

[@tumurereemmanuel4727]

thx a lot, u saved me

[@Alfredox314]

It doesnt even take them a month to change their layout again, ffs microsoft, nope, the button is not there, they keep changing these things, so annoying.

[@MrXL]

If you are in a company, it could be that the I.T. department has used Group Policy to remove this. In that case, try using a Trusted Location as described here: kzbin.info/www/bejne/j2mmgH9rpruVg5Y

[@BillJelen]

If you don’t have the Unblock option, the. Setting up a Trusted Folder seems to work: kzbin.info/www/bejne/j2mmgH9rpruVg5Y

[@radecomskalar2994]

Did not work

[@BillJelen]

Then the next best choice is to save the macro workbook in a trusted location. Those steps are shown in this video: kzbin.info/www/bejne/j2mmgH9rpruVg5Y