Hi,

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

Thanks
Stephane

You can do it with code like the following:

With ThisWorkbook.VBProject.VBComponents("Module1").Cod eModule
.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


"Stephane" wrote in message
om...
Hi,

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

Thanks
Stephane

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

-----Original Message-----
Hi,

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

Thanks
Stephane
.

Stephane

Chip Pearson has the code.

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

Gord Dibben Excel MVP

On 4 May 2004 08:55:04 -0700, (Stephane) wrote:

Hi,

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

Thanks
Stephane