Results 1 to 7 of 7

How can i stop Symantec AntiVirus Corporate Edition from blocking my macro?

This is a discussion on How can i stop Symantec AntiVirus Corporate Edition from blocking my macro? within the Excel Questions forums, part of the Question Forums category; Hey all, I finished writing a new bunch of macro's and now, my antivirus won't let me open it unless ...

  1. #1
    Board Regular
    Join Date
    Mar 2007
    Location
    Sanford, Maine, USA
    Posts
    321

    Exclamation How can i stop Symantec AntiVirus Corporate Edition from blocking my macro?

    Hey all,
    I finished writing a new bunch of macro's and now, my antivirus won't let me open it unless i disable it first because it's bloodhound virus sniffer thinks my document is a virus. i wrote it myself! lol.

    how can i stop it from think this? i can't find a way to make it into an exclusion or something...

    Symantec AntiVirus v10.0.2.2000

    Thanks!
    "Next time, make sure you click SAVE before you accidentally run that infinite loop..."

    Gary Ritter Jr.
    Office Ultimate 2007 & Student Teacher 2003

    My Other Favorite Excel Site: http://www.puremis.net/excel/index.shtml

  2. #2
    Board Regular
    Join Date
    Mar 2007
    Location
    Sanford, Maine, USA
    Posts
    321

    Default Re: How can i stop Symantec AntiVirus Corporate Edition from blocking my macro?

    Bump!

    Can anyone think of a known cause for antivirus to suspect a macro virus? Or how i might go about editing my code to avoid that.
    "Next time, make sure you click SAVE before you accidentally run that infinite loop..."

    Gary Ritter Jr.
    Office Ultimate 2007 & Student Teacher 2003

    My Other Favorite Excel Site: http://www.puremis.net/excel/index.shtml

  3. #3
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    32,832

    Default Re: How can i stop Symantec AntiVirus Corporate Edition from blocking my macro?

    The CAUSE for antivirus software to suspect a macro is a virus...

    Because many viruses ARE VBA Macros...
    VBA code is a VERY commonly used language for viruses...

    It's not that a specific line or set of lines in your code is suspicious. It's just the fact that some VBA code EXISTS that it finds suspicious...

    There's nothing you can do about it in Excel...
    You'll have to adjust settings in the AntiVirus program to TRUST VBA macros.
    Want better/faster responses to your questions?
    Use Excel Jeanie to post samples of your sheet.

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

  4. #4
    Board Regular
    Join Date
    Mar 2007
    Location
    Sanford, Maine, USA
    Posts
    321

    Default Re: How can i stop Symantec AntiVirus Corporate Edition from blocking my macro?

    but it doesn't suspect all my workbooks, just this one in particular. and it didn't from onset, only with the last round of coding i did in it...

    and i don't know if i want to leave my system unprotected for any and all macros...
    "Next time, make sure you click SAVE before you accidentally run that infinite loop..."

    Gary Ritter Jr.
    Office Ultimate 2007 & Student Teacher 2003

    My Other Favorite Excel Site: http://www.puremis.net/excel/index.shtml

  5. #5
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,156

    Default Re: How can i stop Symantec AntiVirus Corporate Edition from blocking my macro?

    You should avoid macros that try to access outlook addresses, if one of your macros is trying to send emails.

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  6. #6
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    3,781

    Default Re: How can i stop Symantec AntiVirus Corporate Edition from blocking my macro?

    Quote Originally Posted by jonmo1 View Post
    The CAUSE for antivirus software to suspect a macro is a virus...
    Not necessarily a virus, just something that it thinks might be a virus.

    Because many viruses ARE VBA Macros...
    VBA code is a VERY commonly used language for viruses...
    When did you last hear of a VBA virus? 1998? VBA would be easy to write a virus in, but i don't think it's a common vector.

    There's nothing you can do about it in Excel...
    You'll have to adjust settings in the AntiVirus program to TRUST VBA macros.
    Uninstalling Symantec would be a good first step. AVG is a good, noninvasive antivirus program, and I've heard good reviews about Avast. However, if you work in a corporate environment, you may be stuck. So as JonMo says, you should try to find options or settings that make your Excel macros work without such interference.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try the Peltier Tech Chart Utility

  7. #7
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,212

    Default Re: How can i stop Symantec AntiVirus Corporate Edition from blocking my macro?

    I had something similar happen years ago. I wrote writing some code for a training course, and Antivirus jumped in and told me I had a virus. Quarantined the file.
    So, I started again and the same thing happened. I rewrote a third time, changing the code, and all was fine.

    If your code has been quarantined, you might just have been unlucky. It's VERY rare but your best option is to try to modify the code (hopefully there isn't too much of it) to avoid this hapening again. I assume you have a prior version so you can work out what you changed?

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com