Microsoft Excel is a powerful tool that empowers users to perform complex calculations and analyse data. One of the features that make Excel even better is macros. Macros are sequences of commands that allow users to automate repetitive tasks, saving time and reducing the risk of errors. However, macros are disabled by default in Excel due to security concerns.
In this article, we have discussed how to enable macros in Excel for a single file and how to change the macros settings.
Also read: How to encrypt an Excel file?
What is a macros security warning?
Even though macros are good at doing hard tasks automatically, they can also be a big problem for security. A bad macro you accidentally run might harm your files, mess up your data, or even break your Microsoft Office. Because of this, Excel is set to block all macros by default unless you permit it. Just remember one simple thing, only use macros that you made or got trusted sources, and only VBA codes that you have reviewed and fully understand.
How to enable macros for a single file?
To enable the macros for a single follow the step below.
Step: When you open a workbook with macros for the first time, you’ll see a yellow security warning bar right below the ribbon at the top of the sheet. Click on the Enable Content button at the end of the warning to enable the macros for the current file.
Also read: How to wrap text in Excel?
How to change macro settings?
To change the macro settings from the trust centre, follow the steps below.
Step 1: Open Excel and click on the Files tab in the toolbar ribbon.
Step 2: Click on the More option at the bottom left corner of the screen and then in the menu click on the Options.
Step 3: In the Excel options window, click on the Trust Center option in the sidebar and then click on the Trust Center Settings button on the right side.
Step 4: Now, in the trust centre, click on the Macro Settings option, and You will be presented with several options for enabling macros. Choose the setting that suits your needs while ensuring security. Here are the options.
- Disable VBA macros without notification: This option provides the highest security by not allowing any macros to run.
- Disable VBA macros with notification: Macros will be disabled, but you will receive a notification each time a macro is present in a file you open.
- Disable VBA macros except digitally signed macros: Macros digitally signed by a trusted source will be allowed to run.
- Enable VBA macros (not recommended, potentially dangerous code can run): This option allows all macros to run without any notifications or restrictions. This setting is not recommended due to security risks.
For most users, Disable VBA macros with notification or Disable VBA macros except digitally signed macros is recommended, as they provide a balance between security and functionality.
After choosing the desired settings, click on the OK button.
Also read: How to record a macro in Excel?