View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Cole, Jr. John Cole, Jr. is offline
external usenet poster
 
Posts: 8
Default 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.