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.
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.
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..
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.
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 ?:
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:
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.
Once you have made your choice, confirm the changes to the macro settings by clicking? Accept ? The Trust Center and Excel Options close.
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:
In the 2007 version, the procedure for Excel 2010 and later changes little: