In this tutorial, we are going to learn how to enable macros in excel.
A point to note is that it is advisable to keep macros disable unless you need the option enabled for your project.
Just a brief overview of macros
Microsoft Office documents — Word, Excel, PowerPoint, and other types of documents may have embedded code written in a programming language known as Visual Basic for Applications (VBA).
However, malicious people could write a VBA code to create macros that can do harmful things. They could then embed these macros in Office documents which could damage your computer if opened.
How to enable/disable macros
- Open a blank Excel sheet.
- On the top left-hand corner of your opened sheet, click on file and scroll down to options (usually the last option) as shown in the figure below.
- On the page that pops up, scroll down to trust center and click on it
- Next click on trust center settings on the right-hand side of the page
- On the page that comes up, look for macro settings (along the middle of the items listed) and click on it.
- The macro settings pop up. Scroll to the last option which is (enable all macros (not recommended, potentially dangerous code can run) ) and check it.
- Now you should be able to open any macro excel file
NB: Unless you need the macro setting enabled, always have it disabled.
If you want to disable the macros, repeat the steps above. But in step 6 choose “disable all macros with notification.”