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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron" wrote in message ...
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,
Thanks for all your help. Your add-in looks pretty slick.

Thanks again.

"Ron de Bruin" wrote:

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron" wrote in message ...
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

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

ThisWorkbook.VBProject.VBComponents("Module2").Cod eModule.DeleteLines
1,
ThisWorkbook.VBProject.VBComponents("Module2").Cod eModule.CountOfLines
ThisWorkbook.VBProject.VBComponents("Module2").Cod eModule.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