Two ways to enable macros in Excel 2010

If you want to significantly increase your productivity while working in Excel, then the best way is to use macros. In short, they contain a set of commands that allow you to quickly perform some kind of complex action that requires the sequential use of various tools, at the click of a button. Next, we will talk about how to enable macros in Excel 2010, but if you use a different version of the program, read the article to the end. The last section will discuss the use of macros in other versions of the program.

Method number 1: Via the "Developer" menu

The easiest way to enable macros in Excel 2010, as in any other version, is through the developer's menu, but the problem is that it is disabled by default, and you must first display it on the screen. Here's how to do it:

1. Run the program.
2. Select the "File" button on the main line.
3. In the menu that appears, select "Options."
4. In the new window that appears after clicking, you need to go to the "Developer" category.
5. Now in the right window, check the box next to "Developer".
6. Click on the "OK" button.

Now, among other tabs with tools, a new one has just been selected by us. Accordingly, we can move on to the question of how to enable macros in Excel 2010:

1. Click on the "Developer" tab.
2. In the "Code" tool group, click on the "Macro Security" button, which is made in the form of an exclamation mark on a yellow background.
3. A new window will appear called the "Trust Center." Find the "Macro Options" section in the list.
4. To enable macros, you need to set the switch to the appropriate position.
5. Click OK.

It is worth explaining that the choice of this item significantly reduces the security of the computer and increases the likelihood of introducing viruses into the system, so be careful when choosing macros and make sure that they do not contain malicious code. To do this, it is best to use an antivirus, each time before adding a macro to Excel, scanning it for malware.

Now you know how to enable macros in Excel 2010, but this is only the first way, there is one more that may seem more convenient to some.

Method number 2: Through the program parameters

So, now we will talk about the second way to enable macros in the Excel spreadsheet editor, it is carried out as follows:

1. Run the program and go to the "File" tab.
2. In the menu that appears, go to the "Options" category.
3. Now you need to go to the "Trust Center" in the new window that opened after clicking.
4. Next, in the right pane of the window, click "Trust Center Settings."
5. As you might guess, after that a window of the same name will appear, which is familiar to us from the previous instruction. In it you need to go to the "Macro Options" section.
6. In the area of ​​the same name on the right, check the box next to "Include all macros" to make them work.

This is how macros can be enabled in Excel 2010. Well, and how to use it, as always, is up to you.

We include macros in other versions of the program

Now we will tell you how to enable macros in Excel 2013. Actually, the algorithm of actions is not very different, you can even say that it does not differ at all. Only the interface of the programs differs, and all the instructions are equally applicable, so you can easily enable macros using the above manual.

If you do not know how to enable macros in Excel 2007, then we will explain. The fact is that the interface is already much different from the 2010 version. So, instead of the File tab, it has the MS Office logo. But there is a fairly simple way to enable macros, here it is:

1. In the menu, go to the "Tools" section.
2. Next, select the line "Macro".
3. Next, click on the "Security" section.

A window will appear where you need to tick the item that will start the inclusion of macros.

Conclusion

Now you know all the ways to activate macros in various Excel programs. We hope that the instructions in this article helped you solve the problem.