View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Julian Julian is offline
external usenet poster
 
Posts: 13
Default Excel macro is recognised as a virus

I have written a macro to connect to Outlook and send emails according to a
list in a worksheet. For about a day, some of the classes and modules kept
disappearing from the workbook when I saved it. I have now tracked this down
to Symantec Antivirus thinking my workbook had a virus and helpfully deleting
all my hard work!

What can I do to avoid this happening? I know this is an awkward question
because this is the way many viruses work. However, Outlook has an object
model that is accessible from Excel VBA and I have a legitimate need to do
this.

Is there anything I can do in the way I write the code? Or will code signing
help?

Thanks for any thoughts and suggestions.

Julian