New to VBA - Help with Deleting Macro's

[Guest]

I have a macro in a workbook that does several things, the last thing is to
save the file under a new name. The reason is that I want to send the saved
file to a customer, but I don't want the macro attached. After the file has
been saved, if I go in and delete the macro, I still get the "Enable",
"Disable" macro pop-up screen when I open the file. Why is this still
showing up after I have deleted the macro, and how can I get rid of it so
that my customers don't see it.
Any help would be appreciated. Thanks

 

[Ron de Bruin]

Hi Ron

You must delete the empty module also
My mail add-in have a option to delete all the VBA in the file you send
http://www.rondebruin.nl/mail/add-in.htm

 

[Guest]

Ron,
Thanks for all your help. Your add-in looks pretty slick.

Thanks again.

 

[MartinK]

Dear Ron
I have been using following code which "modifies itself".

ThisWorkbook.VBProject.VBComponents("Module2").CodeModule.DeleteLines
1,
ThisWorkbook.VBProject.VBComponents("Module2").CodeModule.CountOfLines
ThisWorkbook.VBProject.VBComponents("Module2").CodeModule.InsertLines
1, CodeM

Where CodeM is a any string containing a text of any macro. If You want
to delete it - CodeM is a "".

Greetings

Martin