View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Save File without VB Module

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???