Macro Security

Macros can contain executable code, so Excel provides security settings to control how macros are handled.

Open:

File → Options → Trust Center → Trust Center Settings → Macro Settings

Important

Do not enable macros from untrusted files simply to make a workbook work. Only use macros from sources you trust.

VBA Editor

Open the VBA Editor using:

Developer → Visual Basic

or:

Alt + F11

Important VBA Areas

  • Project Explorer
  • Code Window
  • Properties Window
  • Immediate Window
  • Modules

Practice

Open the VBA Editor and locate:

VBAProject → Modules → Module1

PreviousNext