How Do I Enable Macros In Excel?

What are macros and why are they useful? If we talk about Excel, these are special tools for creating various commands in the program. As a result, the implementation of some tasks will be simplified as much as possible. Time costs will be reduced by automating the process. Hence, the question of how to enable macros in Excel becomes relevant.

There is another side of the coin. For example, macros represent a vulnerability to the system. If you are not sure about the reliability of a particular file, then it is better not to use macros. The reason is simple. Your PC may be attacked by malicious components. This has a number of negative consequences. The issue of turning off macros will be considered. In general, only you ultimately decide whether to use them or not.

Enabling and disabling macros in Excel through the developer menu:

The first option is to use the developer menu. Quite convenient and fast, you just need to know the sequence of actions.

Now directly to how to enable macros in Excel or perform the opposite operation. To access the developer menu, it must be enabled. The section is disabled by default.

To enable, follow these simple steps:

  • Click on the "File" tab at the top of the window.
  • The next step is to select the "Options" item, it is located almost at the very bottom of the left side of the window.
  • A pop-up window will open in front of you. On the left is a menu to switch between tabs. Each contains a specific set of settings. Open Customize Ribbon to continue."
  • On the right side, find the "Developer" item. You just need to check the box opposite and click on "OK".

Now, when you open the program, you will be able to observe the "Developer" tab in the top menu. From here begins the answer to the question of how to enable macros in Excel or deactivate them:

  • Having opened the "Developer" tab, pay attention to the "Macros" settings block. It is located on the very left side of the ribbon with tools. You need to click on the button in the form of a triangle.
  • A pop-up window will appear in front of you. You need to go to the "Macro Options" tab. After that, you will observe a whole list of different options. You just need to choose the one that suits you personally. Be aware that enabling macros is a risk. You are solely responsible for all consequences.
  • When the selection is made, click on "OK" to close the window.

About turning off macros

You may have noticed that there is only one activation option. Meanwhile, there are as many as three variations on how you can disable macros. What's the matter? The whole meaning of the action is described directly in the title of the paragraph. Therefore, you should focus on it.

The last option, "Disable all macros except digitally signed macros," is the most risky. The thing is that deactivation will affect only those elements that do not have a digital signature. The ones mentioned above will still be able to complete the tasks. To apply the changes, do not forget to click on "OK" at the bottom of the window.

Working through program options

An alternative way to enable or disable macros in Excel is based on working with program settings. The algorithm here is extremely clear and easy to understand. You just need to follow a series of instructions:

  • Run the program, then visit the "File" menu section. You already know how to do this, there is nothing complicated about it.
  • Now, by analogy with the previous instruction, you will need to open the "Options" tab. A pop-up window will appear where you need to go to the Trust Center section.
  • On the right side you will see a button. It's labeled "Trust Center Settings...". You need to click on it to go to the next step.
  • You will see a special window that you have worked with before.

Now you know an alternative approach on how to enable macros in Excel. There is nothing complicated in this, since everything is done in a couple of simple steps. You just need to remember that macros are a rather risky decision. That is why first analyze the situation, and then act.

Working with other versions of Excel

Above, you saw instructions on how to enable macros in Excel 2010. However, not everyone uses this particular version of the software. Therefore, alternative information must be provided.

For example, you have MS Office 2013 installed. What to do in this case? Here it should be noted that the algorithm is similar to that described above. No changes were made by the developers, so you will definitely figure out the sequence of actions.

The situation is opposite with versions that were released earlier. For example, you might have Office 2007. In this case, you must click on the program logo in the upper left corner. On the new page, select "Settings".

You will see the Trust Center window. After that, the steps will be the same as in the instructions described above. You need to sequentially review the items "Service", "Macro" and "Security". A window will open where you select the security level for macros. There are four options:

  • "Very high".
  • "High".
  • "Average".
  • "Low".


Now you know how to enable macros in Excel or disable them. It only takes a couple of minutes of your time to implement the instructions. The main thing is to treat the process responsibly so that there are no problems in the future.

Popular posts from this blog

How Do I Clear The Clipboard History In Window 10? -

How Do I Fix My Keyboard is Automatically Typing Problem? -

Office 2019 vs. Office 365: Which Should You Buy?