A macro is a number of Excel assignments and instructions that are included, so that they can be executed as a single assignment.The task for you.To use macros in a workbook, you must activate them on a case -by -case basis or by adding a trusted storage location.
Switch on macros in a single file
Macros are disabled as standard because they are made with visual basic code that can have a negative impact on your computer if they are written or recorded with malignant intention.of the spreadsheet data for each file with a macro.
- click onTurn on contentButton in the security warning above the formula bar.
- Choose whether you want to make this a trusted document.
- In:Macros are automatically activated when this file is opened.
- Nee:Macros must be activated every time this file is opened.
Set reliable locations
If you have many macrophiles in a place, such as a networking station and you do not want to continue to activate content in each file, make a trusted place instead.
- click onFilThe tab.
- to electPossibilities.
- to electTrust center.
The trust center in Excel contains all security and privacy settings that are used to keep your computer safe.
- click onTrust Center -Settingsknob.
The Trust Center dialog box is opened.
- to electReliable locationsIn the left column.
Depending on your setup, you may have a number of reliable locations that have already been added.
- click onAdd a new locationknob.
- click onBrowsingknob.
- Navigate to and select the familiar location in the Review window.
- Cl.Magn.
Excel adds the specific folder that you have selected as a trusted location.
- (Optional) SelectUnderpasses of this location are also confidence inCheck box.
With this selected institution, all folders at the location that you have chosen in the Browse dialog box are also familiar.
- Cl.Magn.
The reliable location is added.You will no longer receive a security warning when you open a file that is stored in the specified folder.
Macro settings
You also have the option of changing the settings worldwide for all files containing macros in the trust center.This can be risky, so if you work with a system administrator in an organization, you can notice that you cannot change these settings.
- to electMacro settingsIn the Trust Center dialog box.
There are four levels of macro protection:
- The first level eliminates macros completely and blocks them without a message.
- The standard setting blocks macros but shows a review.With this message you can activate macros based on case -through -case.
- You can automatically activate digitally signed macros.You will still be asked for most macros, but familiar macros are allowed without quickly.
- Finally, you can activate all macros without promptly.This can be dangerous, so use this assignment with caution.
- Choose the correct security level.
- Cl.Magn.
The Trust Center dialog box is closed and the settings are used for Excel.