How to Enable Macros in Excel: An Easy Guide for All Versions

Microsoft Excel - Photo by Esa Riutta from Pixabay

Apr 23, 2020 12:00 PM

Microsoft Excel is a computer program developed by Microsoft to help working people finish their work with speed and accuracy. This program is designed to help its users do calculating, graphing tools, pivot tables, and also doing macro programming language, which is also called Visual Basic for applications.

Although the main function of Microsoft Excel is to help people to do their works, operating Microsoft Excel might be a little bit confusing for those who do not familiar with this program. There are certain formulas if you want to process numbers or big data in Microsoft Excel. If you are battling with finding the technique of how to enable macros in Excel, then you are on the right track.

Tripboba has all the easy steps on how to enable macros in Excel. Sit back and follow the steps carefully.

Microsoft itself has already released several versions of Excel such as Excel 2016, Excel 2013, Excel 2010, Excel for Mac, and many more. If you are currently stuck and don't know how to enable macros in Excel, this easy guide by Tripboba will be a perfect one for you.

Keep reading until the end of this article to find out the steps. No worries, we have all the guides for all versions of Microsoft Excel, so check it out!

How to Enable Macros in Excel 2016

Even though the latest version of Microsoft Excel is the 2019 one, people are still using the Excel 2016 version. If you have the 2016 version on your computer and currently you want to know how to enable macros in Excel 2016, here is the step-by-step to follow.

Enabling the macros in excel 2016 can be done through the message bar pop-up. On the "Message Bar" you need to select "Enable Content" on the yellow message bar. To enable the macros in backstage view, there are the steps you need to follow:

1. Press the "File" tab button.

2. Click "Security Warning" are and click "Enable Content".

3. Select the "Enable All Content" and then you need to select " Always enable this document's active content" to convert the document into a trusted document.

You can also enable the macros on your Excel 2016 through Security Warning that appears when you open the document. These following instruction could be your easy guide to enable the macros in Excel:

1. First, you need to click the "File" tab.

2. Then select the "Security Warning" area and then click the "Enable Content".

3. You need to select "Advanced Options".

4. Then, in the "Microsoft Office Security Options" area, select the "Enable content for this session" for each macro.

5. Finish up with selecting the "OK" button.

The last option to enable the macro option in Excel from your EXcel 2016 version is to go through the Trust Center. All you need to do is to change the macro setting through Trust Center. You can follow these steps below:

1. Select the "File" tab.

2. Click Options.

3. Select the "Trust Center" and then click the "Trust Center Settings".

4. Selects all the selections you want.

5. And then click "OK".

How to Enable Macros in Excel 2013

For the 2013 version users, these are the steps you need to do on 'how to enable macros in excel":

1. Firstly, open the C10 Entry Sheet and then click the "File" tab.

2. Click "Options".

3. You need to click "Trust Center" on the bottom item, and the "Trust Center Settings".

4. And then select the "Macro Settings".

5. Select "Enable all Macros (not recommended; potentially dangerous code can run), and then click "OK".

6. Lastly, save the spreadsheet. After conducting the actions, you need to reboot your computer to let it working optimally.

How to Enable Macros in Excel Mac

Enabling macros from mac, you need to try the following steps:

1. Click the "Word", "Excel", or "PowerPoint" menu available on your mac.

2. Then select "Preferences".

3. Next, click on "Security & Privacy". You need to enable all macros buttons.

4. You can select "Disable all macros with notification" so you will not be prompted every time you open it.

5. Select "Disable all macros without notification", if you want to silently disable the macros.

Does this article help you in dealing with how to enable macros in Excel? If it helps, now you are ready to continue your works. Happy working!