To Create a New Macro (VBA/ActiveX)

After a VBA project is loaded, you can add a new macro to the project.

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 Macro Name text box, enter a name for the new macro and click Create.

   If a macro with the specified name already exists, you will be prompted to replace the existing macro. Click Yes to replace the macro or No to enter a different name.