Programmatically delete macro using a protected project
 

Can anyone give some help. I have created several projects that
perform similar functions using a .xla file. I have written a macro
that deletes all data from one file when I'm ready to start a new job.
One of the things I need it to do is delete a macro. I am writing
the macro in my add-in, but I want it to delete a macro named
"performParse" from the module 'parse' in the active workbook.

The active workbook isn't protected, but the code in the add-in is
protected.

Programmatically delete macro using a protected project
 

Try here for pointers:-

Programming To The Visual Basic Editor
http://www.cpearson.com/excel/vbe.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"John Cole, Jr." wrote in message
om...
Can anyone give some help. I have created several projects that
perform similar functions using a .xla file. I have written a macro
that deletes all data from one file when I'm ready to start a new job.
One of the things I need it to do is delete a macro. I am writing
the macro in my add-in, but I want it to delete a macro named
"performParse" from the module 'parse' in the active workbook.

The active workbook isn't protected, but the code in the add-in is
protected.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004