Deleting macro

[Stephane]

Hi,

is it possible to delete a macro in VBA code??? If yes, what's the code???

Thanks
Stephane

 

[Bob Flanagan]

You can do it with code like the following:

With ThisWorkbook.VBProject.VBComponents("Module1").CodeModule
.DeleteLines .ProcStartLine("MacroName", 0), _
.ProcCountLines("MacroName", 0)
End With

If you are using Excel 2002 or 2003, you will need to manually tell Excel to
trust macro modifications of vba code. I believe it is found via Tools,
Macros. Set back when done.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Frank Kabel]

Hi
in addition to Bob's answer you may also take a look at
http://www.cpearson.com/excel/vbe.htm

 

[Gord Dibben]

Stephane

Chip Pearson has the code.

http://www.cpearson.com/excel/vbe.htm

Gord Dibben Excel MVP