delete a macro
 

Hi, is there anyway to delete a cetrain subroutine or module using code? If
so could you let me know how to do it.
Thanks.

delete a macro
 

you can delete it manually..... with vba editor open, right click on
the module in the project explorer window...... choose "remove
modulex"...... you can export it first or not.
you can also delete a module programatically, but you'd have to search
the newsgroup to find out how to do that.
susan


Graham Whitehead wrote:
Hi, is there anyway to delete a cetrain subroutine or module using code? If
so could you let me know how to do it.
Thanks.

delete a macro
 

ActiveWorkbook.VBProject.VBComponents.Remove
ActiveWorkbook.VBProject.VBComponents("Module1")

here you will find many interesting samples: http://www.vba-programmer.com/