Macro Security

Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA.
Macro Security setting is different in Excel 2003, 2007 and 2010. Here we will see how we can change the macro security settings in all versions of MS Excel like 2003, 2007 and 2010.
Excel 2003 | Excel 2007

Excel 2003

1. Click on Tools
2. Go to Macro
3. Click on Security.

4. Here you have 4 options.
i) Very High will disable all macros.
ii) High level will only allow macros which are signed by an acknowledged trusted source.
iii) Medium will confirm before running the running.
iv) Low will enable all macros without any condition.

Excel 2007

1. Go to “Developer Tab”
2. Click on Macro Security
3. Go to Trust Center
4. Click on Macro Settings

Here also we have 4 options:
i) Disable All macro without notification: This will not allow to run any of the Macro.
ii) Disable Macro with notification: This will not allow to run the macro, but it will show a notification.
iii) Disable All Macro except Digitally signed Macro: This allows only those macros which are digitally signed.
iv) Enable All Macros: This allows to run all the macros without any notification.

Buy a coffee for the author

Download FREE Tools and Templates

There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.

Hurray..Lets Go

Convert PDF Tables to Excel with VBA | Step-by-Step Guide

Dec 4, 2024

Convert PDF Tables to Excel with VBA | Step-by-Step Guide How to Convert PDF Tables to Excel Using Excel VBA (Macros) Extracting data from PDF tables into Excel can be tedious, but with Excel VBA (macros), you can automate this process and save time. This guide will...

Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide

Feb 9, 2024

In today's tutorial, we'll be diving into the exciting world of dynamic arrays and spill functions in Office 365 Excel. These features have revolutionized the way we work with data, providing a more flexible and efficient way to handle arrays. I am going to explain...

How to Declare a Public Variable in VBA

Feb 3, 2024

While programming in VBA sometimes you need to declare a Public Variable that can store the value throughout the program. Use of Public Variable: Let's say you have 4 different Functions in your VBA Code or Module and you have a variable that may or may not be...

What is Excel Formula?

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).

Know more

3 Comments

Sandeep Kothari on June 10, 2018 at 6:42 am

When we enable content in an excel file, does it have anything to do with some macro that may be stored in the file?
Reply
Sandeep Kothari on June 10, 2018 at 6:43 am

When we enable content in an file, does it have anything to do with some macro that may be stored in the file?
Reply
- Vishwamitra Mishra on June 14, 2018 at 1:45 pm
  
  Yes, macro is also one of the reason. Enable content button appears when document finds any external content which may be harmful.. this gives this warning. Macro is one of those external information. You can disable it by changing the settings in Trusted center of Excel document, but it is not recommended.
  Reply