Trucos y Tutoriales de Excel

Enable macros in Excel: fix the security warning

Post actualizado el día octubre 26, 2026 by DeiviSanzPlay

You double-click an .xlsm file, Excel throws a yellow warning bar, and suddenly you’re stuck. Sound familiar? Opening an Excel file with macros is one of those things nobody teaches you until you actually need it. And if you’re here, it’s probably because you’ve already hit that wall.

Let me cut through the noise: macros aren’t dangerous by themselves. Microsoft just decided that a format capable of running VBA code deserves a speed bump. That speed bump is the Trust Center, and once you understand it, the whole «can’t open Excel file with macros» drama disappears.

Why Excel Blocks Macros in the First Place

Macros are small programs written in Visual Basic for Applications (VBA). They can automate reports, clean data, send emails, whatever. They can also wipe a folder or download malware. That’s the trade-off.

Since 2016, Microsoft added a layer on top of the classic macro warnings: files downloaded from the internet get a «Mark of the Web» tag. Even if you enable macros globally, Excel will refuse to run them on a file that came from an email or a random download link. This is why so many people say «I enabled macros and it still won’t work.» The block isn’t the macro setting, it’s the file’s origin flag.

So the real question isn’t just how to enable macros in Excel. It’s how to do it without turning your machine into a playground for the first malicious .xlsm that lands in your inbox.

Step 1: Unblock the File Before Opening It

Before you even touch the Trust Center, right-click the .xlsm file and open Properties. At the bottom of the General tab, if you see a checkbox that says «Unblock,» tick it and hit Apply. That single click removes the internet flag Windows slapped on it.

If that checkbox isn’t there, the file didn’t come from the internet and this step doesn’t apply. Don’t go hunting for it.

Do this every time you open an Excel file with macros that arrived via WhatsApp, email, or a download link you don’t fully trust. It takes two seconds and saves you half the headaches people complain about online.

Step 2: Open the File and Read the Yellow Bar

Now open the workbook. You’ll see a yellow security bar under the ribbon saying «SECURITY WARNING: Macros have been disabled.» Next to it, a button labeled Enable Content.

Click it only if you know where the file came from. That’s the whole point. Excel isn’t asking you to prove you’re a genius, it’s asking you to confirm trust. If your accountant sent it, click. If it’s an attachment from an unknown sender with a subject line like «URGENT INVOICE,» close it and delete it.

Once you click Enable Content, the macros run and the file behaves as intended. If the button is greyed out or missing, your Trust Center settings are the culprit, and that’s what we’re tackling next.

Step 3: Tweak the Trust Center (The Real Fix)

Go to File > Options > Trust Center > Trust Center Settings > Macro Settings. Here you have four options, and the difference between them matters more than most guides admit:

  • Disable all macros without notification: the safest and the most annoying. Excel won’t even tell you a macro was blocked.
  • Disable all macros with notification: the default. Yellow bar appears, you decide.
  • Disable all macros except digitally signed macros: good for corporate environments where IT signs everything.
  • Enable all macros: never use this on a personal machine. Ever.

Stick with «Disable all macros with notification.» It’s the only setting that gives you both security and flexibility when you need to open an Excel file with macros enabled.

What About Trusted Locations?

There’s a better trick than enabling everything: create a dedicated folder like C:ExcelTrusted and add it under Trust Center > Trusted Locations. Any .xlsm file you drop there opens with macros running, no warnings, no clicks. It’s the cleanest solution for people who work with macro-heavy files daily.

The catch: only put files there that you’ve verified. The whole point of a trusted location is that you’re the one vouching for it, not Excel.

Step 4: Run the Macro Once It’s Open

If the file has macros but nothing happens automatically, you need to trigger them manually. Press Alt + F8 to open the Macro dialog. You’ll see a list of available macros in that workbook. Select one and hit Run.

If you can’t see the Developer tab, enable it: File > Options > Customize Ribbon and check «Developer» on the right column. From there you get the Visual Basic editor, the Macros button, and everything else you’d need to inspect what a macro actually does before running it.

That last part matters. If you’re unsure about an Excel file with macros, opening the VBA editor and reading the code takes five minutes and tells you whether it’s just formatting cells or calling out to the internet.

The Honest Take on «Enable All Macros»

Plenty of tutorials tell you to just enable everything and move on. Bad advice. VBA has been used in real ransomware campaigns, and the Mark of the Web system exists precisely because too many people clicked «Enable Content» without thinking.

Use trusted locations, unblock files before opening, and keep the notification setting on. That’s how you open an Excel file with macros in 2026 without gambling with your data. If a file looks sketchy, it probably is. Trust your gut, not the yellow bar.