How to enable macros in Excel
Before we learn how to enable macros in Excel, it is important to know the potential risks macros can expose you to 💀
Where macros can save you so many repetitive tasks and do good for you, they can also damage your workbook, hard drive, and even your Microsoft Office installation.
Not to exaggerate but, macros can even delete files from your hard drive if run without due precaution. This is why by default, Excel disables all macros under notification to the user 🚩
Does that mean we should not run macros at all? Obviously not. But it is strongly suggested to run only safe macros, that are duly reviewed by you and are trusted.
This way you’d be saved against any potentially dangerous code and other macro viruses.
There are two prime ways how you can enable macros in Excel.
Through the Message Box
Under the default Excel settings, macros are disabled.
So whenever you launch a book containing macros, you’ll see the following yellow warning message at the top of your sheet 👀
This is the notification through which Excel disables the macros of that workbook. To enable macros:
Click on “Enable Content” from this macro security warning message.
The subject workbook is now a trusted workbook, and the macros are enabled.
If you have accidentally crossed the yellow pop-up as above instead of enabling it, no worries 🤯
Close down the workbook and relaunch it. You’d again find the same warning message, and you can enable it.
From the Backstage
The other way how you can enable macros in a particular workbook is through the Backstage method. To do so:
- Go to the File Tab.
- Click on Info from the left Pane.
- Click on Enable Content > Enable All Content from the Security Warning Area
And that’s it. Your workbook is now a trusted one.