Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The macro security levels in Excel changed starting with Excel 2007.

 

Expand
titleExcel 2000 - 2003...

Very High

Only macros installed in trusted locations will be allowed to run. All other signed and unsigned macros are disabled. Not available in Excel 2000. Not recommended for use with Option B. (Option B features will only be available with significant setup effort.)

High

Default setting; only signed macros from trusted sources will be allowed to run. Unsigned macros are automatically disabled. Recommended for Option B, unless you need a lower setting for other reasons.

Medium

You can choose whether or not to enable macros in a particular workbook; digital signatures are not required. Acceptable for Option B.

Low

Enable all macros. Not recommended, potentially dangerous code can run.

Note

We previously recommended that you change the macro security level to Medium. At that time we were not signing the macros, so Medium security was the best setting compatible with Option B.

Expand

...

titleExcel 2007 - 2013...

Disable all macros without notification

Not recommended (Option B features will not be available.)

Disable all macros with notification

Default setting; acceptable for Option B.

Disable all macros except digitally signed macros

Recommended for Option B.

Enable all macros

Not recommended (potentially dangerous code can run)