How to Enable Macros in Excel in Windows 10

Windows 10 is an operating service. It is a service by Microsoft. This provides various applications on the same. Excel is one of those applications. Further, users use it widely. A macro is command series. It used for repetitive tasks. Sometimes the users face the problem ‘How to Enable Macros in Excel in Windows 10?’. So, looking towards this, we are giving information here. On the other hand, get yourself ready to grab this opportunity. We have also covered the article on ‘How to Freeze Rows in Excel‘. Thus, here we focus on a high-demand query ‘How to Enable Macros in Excel in Windows 10?’.

How to Enable Macros in Excel in Windows 10?

To enable macros in Excel is a necessary task. While performing some tasks, the problem of enabling macros to occur. Thus, it becomes needful to know how to solve it. For the same reason, we are giving a tutorial ‘How to Enable Macros in Excel in Windows 10?’. So, let’s have a ride on this informative journey.

Image Source: Microsoft Community

Different Methods for Enabling Macros in Excel in Windows 10

There are various ways to enable the macros. You can make use of them. But, we are providing some of them here. You should follow them to do so.

Method – 1 ) Through Security Warning Bar

You can enable the macros through the security warning bar. You must follow the steps below to do so.

Step – 1 ) Open the document

When you open the document with the macros, the yellow warning box displays.

method 1 How to Enable Macros in Excel in Windows 10 step 1
Image Source: ablebits.com

Step – 2 ) Click on the ‘Enable Content’ Option

Further, you should click on the ‘Enable Content’ Option. By doing so, the macros gets enabled.

Thus, using this method, you can enable the macros.


Method – 2 ) Through ‘Backstage View’

This is another way to enable macros. You should follow these steps to do so.

Step – 1 ) Select the ‘File’ Option

First of all, click on the ‘File’ option. Further, select ‘Info’ option from the list.

method 2 How to Enable Macros in Excel in Windows 10 step 1
Image Source: spreadsheeto.com

Step – 2 ) Select ‘Enable All Content’

After that, there will be the ‘Security Warning’ window. Now, select the ‘Enable All Content’ after clicking on the ‘Enable Content’ option. This will lead to the following window.

enabling all content window
Image Source: spreadsheeto.com

Thus, using this method, you can enable the macros.


Method – 3 ) Enabling Macros for the Current Session

This is another method for macros enabling. Follow the steps given to perform the operations.

Step – 1 ) Select the ‘File’ Option

The first thing you should do is to select the ‘File’ option.

Step – 2 ) Select ‘Advanced Options’

Further, the ‘Security Window’ opens. Now, select ‘Advanced Options’ after clicking on the ‘Enable Content’ option. In addition, you will see the ‘Enable content for this session’ option. Exactly below that, click on the ‘Ok’ option.

method 3 How to Enable Macros in Excel in Windows 10 step 2
Image Source: ablebits.com

Thus, using this method, you can enable the macros for the current session.


Method – 4 ) Enabling Macros through the ‘Trust Center’

Macros can be enabled through the ‘Trust Center’. This has the following process.

Step – 1 ) Select the ‘File’ Option

The first thing you should do is to select the ‘File’ option.

Step – 2 ) Select the ‘Trust Center Settings’

Further, select the ‘Trust Center Settings’ from the option ‘Trust Center’. This is an important step.

method 4 How to Enable Macros in Excel in Windows 10 step 2
Image Source: ablebits.com

Step – 3 ) Select ‘Enable all micros’

Moving ahead, select the ‘Enable All Micros’ option after clicking on ‘Macro Settings’. After that, click on ‘Ok’ option.

enabling all micros window
Image Source: ablebits.com

Thus, using this method, you can enable the micros.


In this way, following the above-mentioned methods, you can enable micros.