| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete a macro
ActiveWorkbook.VBProject.VBComponents.Remove
ActiveWorkbook.VBProject.VBComponents("Module1") here you will find many interesting samples: http://www.vba-programmer.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Linear Mode
