Tutorial – How to Enable Excel Macros

posted in: Excel Tutorials | 0

Tutorial – How to Enable Excel Macros

 

In this tutorial we will outline how you can enable Excel macros in Microsoft Excel. It is not a difficult process to Enable Excel Macros but it is a key step if you wish to use Macros in your spreadsheet. This guide will work with Excel 2007, Excel 2010 and Excel 2013. Once you have completed these steps you will be able to create and save Macro Enabled Excel workbooks.

 

Macros are not enabled in Microsoft Excel by default, but once you have Enabled Excel Macros your version of Excel should remain in the Enabled state. So you should only need to follow this guide once, unless you upgrade or reinstall you version of Excel.

Excel Macro Enable Video Tutorial

 

Excel Macro Enable guide

 

Enabling Macros in Excel 2007 only.

 

The first thing you need to do is open your version of Excel. Once you have done this you will need to Enable the developer tab so that this shows up on your ribbon. This is where all of your Macros are edited and inserted from. To do this, press the home button in the top left of your screen and then press Excel Options.

excel enable macros

 

From there you will need to navigate to “Popular” and check the box which states “Show Developer Tab in the Ribbon”.

enable macros excel

 

You will then need to Navigate to the “Trust Center” and Press “Trust Center settings”.

macro enabled excel

You then need to press Macro Settings and then click the bottom checkbox which reads “Enable all macros (not recommended, potentially dangerous code can run).

excel enable macro

Then press OK

The next section will explain how to enable macros in Excel 2010, Excel 2013 and above so please view below if you have these versions.

Excel Macro Enable guide

Enabling Macros in Excel 2010, Excel 2013 and above.

The first thing you need to do is open your version of Excel. Once you have done this you will need to Enable the developer tab so that this shows up on your ribbon. This is where all of your Macros are edited and inserted from. To do this, press the home button in the top left of your screen and then press Excel Options.

enable excel macros 2010

One you have done this you will then need to navigate to the “Customize Ribbon” button on the left hand side of the side of the menu. Once here you will need to check th box in the right hand side window which reads “Developer”. This will enable the Developer tab on your ribbon.

 

enable excel macros 2013

You will then need to Navigate to the “Trust Center” and Press “Trust Center settings”.

macro enabled excel

You then need to press Macro Settings and then click the bottom checkbox which reads “Enable all macros (not recommended, potentially dangerous code can run).

excel enable macro

Then press OK

 

We hope that this has been helpful, please visit the YouTube channel for more tutorials and guides.

Leave a Reply