Hi DynamiteSkippy
You can look at Chip's page for code to do this
http://www.cpearson.com/excel/vbe.htm
I always send the file with My Mail add-in that have a option to delete the code in the file you send
http://www.rondebruin.nl/mail/add-in.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"DynamiteSkippy" wrote in message
...
Is there a way to save a file without a particular module being saved?
I have a client who is extremely sensitive and doesn't like the macro
security message which pops up anytime there is a file which has visual basic
code in it.
I simply want to eliminate that message from popping up and force it to
"Disable Macros" Any thoughts???