View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Save File without VB Module

Just one more thought,

I don't know the complexity of your spreadsheets, but you may consider
simply copying your sheets into a "clean" file and send that one instead. You
could even code a macro to do it for you...

HTH

"DynamiteSkippy" wrote:

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