View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default VBA & User Form modules vanish

I think some aggressive antivirus programs can do the same kind of thing.

Maybe zipping the workbook would fool that AV software (well, if it is the AV
software causing the trouble).

Pete wrote:

Can anyone shed any light on why/how an Excel spreadsheet could
mysteriously "lose" the modules for both user forms and VBA? It seems
to be happening on emailing using Outlook, but the real mystery is that
it's intermittent - a spreadsheet sent one day will arrive without the
modules but if I re-send it then it will in all likelihood keep the
modules.

I have been told it might be 3rd party email safety software but if
that's true then why aren't all my spreadsheets stripped of the modules
when I send them?

Any hints gratefully accepted

Peter UK


--

Dave Peterson