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.