Enable Macros in Excel

You can enable macros in Excel by setting your Excel Security Level:

  • Office 2000-2003:
    Menu :: Tools :: Macros :: Security.
  • Office 2007:
    Microsoft Office Button :: Excel Options :: Trust Center :: Center Settings :: Macro Settings.

You can set Security to High, Medium or Low:

  • High Security.
    All Excel macros (except from trusted sources) are disabled.
  • Medium Security.
    User is prompted on each file-open to enable or disable Excel macros.
  • Low Security.
    Excel Macros can run automatically without a prompt. You are not protected from potentially unsafe macros.