+4 votes
34 views
in Sell ​​on the Internet by (76.4k points)
reopened
Enable Excel macros: this is how handy scripts are activated

1 Answer

+5 votes
by (506k points)
edited
 
Best answer

image

Enable Excel macros: this is how handy scripts are activated

Since its first version in 1985, the spreadsheet program Microsoft Excel has been one of the most requested solutions for creating tables, which includes among its functions the graphical representation of data in diagrams and the calculation of complex formulas and commercial functions. , statistical and mathematical..

One of the most outstanding features of Excel is the neat and functional user menu that, among other things, offers sorting, grouping and filtering functions, as well as different data import and export options. As of version 5.0, it is also possible to automate processes and actions in Excel by using macros . We show you how this function is enabled in the different functions of the spreadsheet.

Index
  1. How to activate Excel macros?
    1. Enable macros in Excel 2019, 2016 and 2013
    2. Enable macros in Excel 2010: this is how it works
    3. Enable Excel 2007 macros: step-by-step instructions

How to activate Excel macros?

Macros offer extraordinary possibilities in Excel to facilitate your work with the spreadsheet program. However, they are known for their security flaws, as they are small applets that can also contain malicious code that, in the worst case, blocks the operating system. For that reason, Excel macros are not enabled by default, or they are only partially enabled. Generally, all macros are disabled and all macros without digital signature are disabled, so the corresponding scripts cannot be executed after import or programming..

The following instructions show you how you can modify the settings in the different versions of the Microsoft application and enable the desired type of Excel macros.

advice

You will find detailed information on how Excel macros work and benefits , as well as a short introduction to programming or recording macros , in our basic guide to Excel macros..

Enable macros in Excel 2019, 2016 and 2013

If you want to enable macros in Excel 2013 and in the successive versions 2016 and 2019, enter the so-called Trust Center . This menu of options contains different settings intended to provide security for your device and the protection of relevant data while using Excel. There you can set, for example, reliable storage locations or find settings for general access protection as well as for? Protected view? Excel folder. In this security menu you will also find the macro settings that will allow you to enable or disable Excel macros.

The first step is to access the tab? File ? Excel. First, the program opens by default the "Information" menu. From the side menu on the left, switch to? Options ? pressing the button of the same name.

image
You can also access the Excel options using a combination of keys: to do this, you just have to press the [Alt], [D] and [O] keys consecutively.

Does the Microsoft application open the dialog window? Excel Options ?, which includes different categories, such as the Trust Center. Click on this menu item and then on the button ? Trust Center Settings ?:

image
If you click on the link? Microsoft Trust Center ?, among other things, you will get information about the latest security features and data protection measures from Microsoft.

In the Trust Center pop-up window, select the menu? Macro settings ?. There you can enable Excel macros by selecting one of these three options:

  • Disable all macros with or without notification : This default setting basically foresees that Excel macros are not activated. If you choose this option with notification, you will receive a warning when a macro is discovered or needs to be executed, and then you will have the possibility to enable it through this special notification.
  • Disable all macros except digitally signed ones : this setting has very few differences from the previous one. The only difference is that macros with trusted publisher signatures (which can also be defined in the Trust Center) also run without asking.
  • Enable all macros : with the last option you can enable all Excel macros, so Microsoft will warn you of the security risks associated with it. If you also want to use macros from third parties or third party editors, in that case you will be solely responsible for evaluating the security.
Note

Some Excel macros can only be used if you have also activated the option? Trust access to the VBA project object model ? To do this, you just have to put the check symbol in the corresponding box.

image
If you have enabled some or all Excel macros, you can override this setting at any time from the Trust Center and disable the snippets again by modifying your choice.

Once you have made your choice, confirm the changes to the macro settings by clicking? Accept ? The Trust Center and Excel Options close.

Enable macros in Excel 2010: this is how it works

Macros are also disabled by default in Excel 2010 for security reasons and are enabled in the same way as in newer versions of the spreadsheet program, through the Trust Center. Here is the procedure:

  1. Access the tab? File ?.
  2. On the left side menu, click? Options ?
  3. Select the menu option? Trust Center? and press the button? Trust Center Settings ?.
  4. Select the desired option to enable Excel macros (for example? Enable all macros?).
  5. Click? Accept ? twice for the modifications to be saved.

Enable Excel 2007 macros: step-by-step instructions

In the 2007 version, the procedure for Excel 2010 and later changes little:

  1. Click on the Microsoft Office symbol (top left).
  2. Click on? Excel options ?.
  3. Select the menu option? Trust Center? and press the button? Trust Center Settings ?.
  4. Go to the category? Macro Settings? and, there, activate the desired option for Excel macros.
  5. Close the Trust Center and Excel Options by pressing the button? Accept "in both cases.

...