Alright, let’s be truthful. You’ve undoubtedly experienced some anxiety if you’ve ever opened an Excel document and noticed the yellow warning box that reads, “Macros have been disabled.” Or perhaps you clicked around in the hopes that it would disappear. In any case, if you know how to activate them, macros can seem like one of those enigmatic Excel features that seem technical yet are incredibly helpful.
Let’s keep it straightforward and dissect it step by step. Just a basic tutorial on how to enable macros in Excel, their importance, and some tips to avoid unintentionally damaging your spreadsheet or, worse, your computer—no coding, no worry.
To begin with, what exactly is a macro?
Let’s first clarify what a macro is before we begin clicking buttons. A macro is simply a recorded series of activities in Excel, to put it simply. For example, suppose you have to perform data copying, formatting, and computations on a daily basis. By recording a macro once, you may execute it with a single click, eliminating the need to manually repeat all those steps. It resembles automation in Excel.
Although VBA (Visual Basic for Applications) is used to write macros, you are not need to touch code if you choose not to. Simply click the “Record Macro” button to record a macro, and Excel will handle the coding for you.
The problem is that, if you’re not careful, macros may include harmful code. Excel suppresses them by default because of this. Before they will work, you must provide them authorization.
Why Excel Automatically Turns Off Macros
So, yes, many people are confused by this portion. It’s not just Microsoft being obnoxious. If they originate from a malicious source, macros can be harmful. Suppose you download an Excel file from a dubious source, and it contains a macro that either deletes files or installs a virus. Unsettling material.
Therefore, unless you explicitly tell Excel, “Hey, I trust this file,” it will automatically disable all macros. For this reason, whenever you view a spreadsheet that contains macros, you will likely notice a red or yellow bar at the top that reads something like:
“Security Warning: We have disabled macros.”
Enabling macros isn’t a huge concern, though, if you’re working with files you know are secure (such as those you created yourself or from your work).
The Simplest Method for Enabling Macros (File by File)
Alright, let’s finally get to the main reason you’re here: learn how to make Excel macros work. Opening a file and seeing the yellow security warning is the simplest method.
What to do is as follows:
Get the Excel file open.
Examine the spreadsheet’s top. A yellow bar that reads, “Macros have been disabled,” will appear.
A button labeled “Enable Content” or “Enable Macros” ought to be present. Press it.
That’s all. In that file, macros are now operating.
The caveat is that this only applies to that file for the duration of that session. You will need to click “Enable” once again if you close and reopen it. You must adjust the settings if you want Excel to remember your selection for all time.
Setting Up a Trust Center to Make It Permanent
If you’re sick of hitting that button repeatedly, you can configure Excel to permit macros for files or folders that you trust.
Here’s how:
Launch Excel (a blank workbook will do).
Select File > Options.
Select Trust Center from the menu on the left.
On the right, select Trust Center Settings…
Next, select Macro Settings.
Here are some choices for you to consider:
Blocks everything when all macros are disabled without warning. Nothing but stillness, no warnings.
By default, all macros with notifications are disabled. displays a yellow bar.
Turn off all macros besides those that are digitally signed. Only macros signed with a trusted certificate are permitted.
Turn on every macro (not advised) – permits everything, including dangerous things. Make sure you know what you’re doing before choosing this.
Select “Disable all macros with notification” if you wish to use macros frequently while remaining secure. In this manner, you can choose each file and at least receive a warning first.
Trusting Particular Folders (To Avoid Having to Turn On Every Time)
You can instruct Excel that “everything in this folder is safe” if you have files in a certain folder, such as a shared team folder or personal macro files. Don’t bother me.
To do that, follow these steps:
Once more, select File > Settings > Trust Center > Trust Center.
On Trusted Locations, click.
Click “Add new location.”
Go to the folder containing your macro-enabled files.
If necessary, check the box that reads, “Subfolders of this location are also trusted.”
Press OK.
Any file that contains macros that is opened from that folder will now launch macros automatically and without notice.
Types of Macro Files: Avoid Saving in the Wrong Format
Saving a macro-enabled file as the incorrect type is just another rookie error. Your macros will be removed if you utilize them in an Excel sheet and save it as a standard.xlsx file.
Workbooks using macros should always be saved as.xlsm files. The last “m” stands for “macro.” If you click Save As while making macros, select:
Excel Macro-Enabled Workbook (*.xlsm) is the file type.
It’s the format that preserves your macros. They cannot be saved in the standard.xlsx format.
Bonus: If you’re interested, record your first macro.
Although this isn’t specifically about turning on macros, it’s still worthwhile to give them a try if you haven’t already. Even knowledge of programming is not required.
This is how to record a very simple macro:
Launch Excel.
Navigate to the ribbon’s View tab.
Select Record Macro under Macros.
Don’t use spaces when naming your macro.
Select whether to keep it in your own macro workbook or this one.
Press OK.
Now take an action, such as formatting a cell, typing, applying colors, etc.
Return to Macros > Stop Recording after you’re finished.
Boom. You’ve just created your first macro. The same Macros menu can be used to run it.
Be cautious when you’re out there.
Finally, before we conclude, avoid enabling macros on files that you find on the internet. Really. Don’t click Enable if you don’t know the sender or weren’t expecting the spreadsheet, even if they send it to you by email with the words “check this out.” Although macros have many positive uses, they can potentially be used for malware or phishing.
That is the original purpose of the Trust Center.
Conclusion: Macros Aren’t Horrible, They’re Just Misunderstood
Ultimately, macros are merely instruments. They can save you a ton of time, particularly when using Excel for repetitive chores. And it only takes a few clicks here and there to enable them.
They become a standard component of your Excel process as you become accustomed to them. Because it’s quicker, you can even find yourself creating macros for pointless tasks like copying data or generating reports.
Don’t freak out the next time that yellow bar appears. You’re capable.