After a VBA project is loaded, you can delete a macro in the project. 
- On the ribbon, click Manage tab 
 Applications panel 
 Run VBA Macro.  
- In the Macros dialog box, Macros In drop-down list, select the project file you want to work with. 
 
- In the Macros list, select a macro and click Delete. Click Yes to delete the macro or No to keep the macro. 
 
You can also work with macros in a loaded project file using the VBARUN command.