Delete a Macro

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

Is there a way to create a macro that deletes other macros
and / or deletes modules?

Thank you,

Steven
 
Chip said:
Steven,

See www.cpearson.com/excel/vbe.htm for details and example code.
Click to expand...

Chip,

If McAfee VirusScan ASaP is installed, this won't work.
McAfee is very effective at zapping the entire code module when you
have a line of code that changes the VBA project. More precisely,
McAfee considers the following methods as possible viral actions:

VBComponents.Add
VBComponents.Remove
VBComponents.Import
CodeModule.InsertLines
CodeModule.DeleteLines

I don't know about other McAfee products or AV products from other
companies, but I think a precautionary warning on your website might be
appropriate.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Excel 2003 - VBA to get a list of Module names in the project 4
Skip Run macro if module has been deleted 1
Delete all object 1
How to call module function or sub from the Add In? 3
Trying to recover deleted macros 0
write vba to a worksheet via a macro 3
When something in module is shown as a macro 3

Back
Top