Whether you're working a spreadsheet or dominating in the virtual battlefield, macros can be the key to success — and that's especially true in Excel. So we're going to teach you how to enable macros in Excel.
But today we'll walk you through how to enable macros in Excel.
How to enable macros in Excel
There are two methods — the first one being the easiest, as you'll get prompted if you attempt to use macros in Excel.
Security warning: Upon receiving a security warning when you open a document or try to use a macro, Excel will ask if you want to make this file a Trusted Document. Click Yes. And everything should work easily. If you do not receive a security warning, follow the steps below.
Step 1. Select File > Options.
Step 2. Head over to Trust Center, then click Trust Center Settings.
Step 3. Click Macro Settings on the left side.
Step 4. Customize the variation of macros you'd like to enable or disable, then hit OK.
Relatively painless even without the security warning. Now you should be able to run your macros without issue.
Stay in the know with Laptop Mag
Get our in-depth reviews, helpful tips, great deals, and the biggest news stories delivered to your inbox.
Rami Tabari is an Editor for Laptop Mag. He reviews every shape and form of a laptop as well as all sorts of cool tech. You can find him sitting at his desk surrounded by a hoarder's dream of laptops, and when he navigates his way out to civilization, you can catch him watching really bad anime or playing some kind of painfully difficult game. He’s the best at every game and he just doesn’t lose. That’s why you’ll occasionally catch his byline attached to the latest Souls-like challenge.