View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default 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