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 is 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?’.
Table of Contents
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 on ‘How to Enable Macros in Excel in Windows 10?’. So, let’s have a ride on this informative journey.
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.
Step – 2 ) Click on the ‘Enable Content’ Option
Further, you should click on the ‘Enable Content’ Option. By doing so, the macros get 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 the ‘Info’ option from the list.
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.
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 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.
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 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.
Step – 3 ) Select ‘Enable all micros’
Moving ahead, select the ‘Enable All Micros’ option after clicking on ‘Macro Settings’. After that, click on the ‘Ok’ option.
Thus, using this method, you can enable the micros.
In this way, following the above-mentioned methods, you can enable macros.