Here’s a guide on how to enable macros in Excel. Like almost any technology, macros can be used for both good and bad. Therefore, in Microsoft Excel, all macros are disabled by default.
This Tutorial covers various ways to enable macros in Excel and explains the potential risks associated with them.
What is Macro?
Microsoft Excel macros are often used to automate certain procedures. Macros are a series of activities executed on a spreadsheet that often save a lot of time.
However, macros may be misused, and there is a danger in enabling macros on documents you obtain from unknown sources. Excel disables macros by default because of this danger.
If you have a document with macros and trust the source or know that it is a secure file, you can enable macros on Microsoft Office programs.
When enabling macros, pay attention to the following factors:
- The VBA code File should be saved as a “Macro-enabled workbook”. The VBA code is not saved when the file is saved with another extension, so macros are not enabled.
- The “Enable all macros” option means running all macros without additional notification or authorization. This may be a problem if macros from trusted and untrusted sources are enabled at the same time.
- The option “Disable all macros without notification” means that it does not explain why macros do not work. To read the alert, select “Disable all macros with notification”.
How to enable macros in Excel on Windows PC
Follow the tutorial steps on how to enable macros in Excel on your Windows PC below.
1. Open your Excel on PC.
2. Click on the “File” tab in the upper left corner, and select the “Options”menu.
3. Navigate to” Trust Center Settings “in the”Microsoft ExcelTrust Center”.
4. From the “macro settings” menu, select one of the access levels you want to enable.
5. Press “Ok”.
6. In the “ActiveX settings” option, select “Enable all controls without restrictions and prompting”.
7. Select to “Ok” to confirm the change of macro settings.
How to enable macros in Excel 2016 or later
1. Open your Excel and click “Preferences”.
2. Select the “Security and Privacy” option.
3. Now follow the same steps=steps mentioned above. Select the option “Enable all macros”.
This option will allow any macros, both good and bad, to be executed without further notice. Select this option only if you are sure that you will not open the malicious file.
How to enable macros in Excel 2011
1. Select” Preferences ” from the Excel menu.
2. Click the “Security” Button and then “Security Preferences” under the “Sharing and Privacy”option.
3. Select one of the following options:
Uncheck the box labeled” Warn before opening a file ” that contains macros. Do this if you want to activate the file when you open it.
Make sure “Warn before opening a file” with the macro checkbox is checked. Do this if you want to see a warning message when you open a file that has macros.
How to enable macros in Excel 365 Online
Here are the steps on how to enable macros in Excel in 365 Online.
1. Find Your Excel program and open it.
2. Select” File ” in the upper left corner of the program.
3. Click on “Options” from this menu.
4. Select “Trust Center”.
5. Select the “Trust Center Settings”option.
6. Select “Macro Settings”.
7. Click the Ok button after selecting the desired macro configuration option. These options are exactly the same as those on Windows and Mac.
That’s the guide on how to enable macros in Excel. I hope this article was helpful to you! Thank you for visiting.