To Edit a Macro (VBA/ActiveX)

Macros in a loaded VBA project file can be edited in the VBA IDE.

1. On the ribbon, click Manage tab Applications panel Run VBA Macro.
2. In the Macros dialog box, Macros In drop-down list, select the project file you want to work with.
3. In the Macros list, select a macro and click Edit.