NAV bloodhound

[RobBroekhuis]

Anybody ever run into the Norton Antivirus bloodhound macro-virus protection? My company requires use of NAV, and ever since I added the following little snippet of code:

   If Not ThisWorkbook.IsAddin Then
      If MsgBox("This tool can be saved as an add-in, so that it " & vbCrLf & _
                " will be available every time Excel starts up.  Would you like to do this?", vbYesNo) = vbYes Then
         s = Application.StartupPath
         s = Left(s, Len(s) - 13)
         ActiveWorkbook.SaveAs s + "addins\RC1 toolbox.xla", xlAddIn
         Application.AddIns("RC1 toolbox").Installed = True
      End If
   End If

to my workbook.open sub, NAV goes after my application like a bloodhound, quarantining it and telling me I can't have it back. Is there a way around (or a better way to make a self-installing add-in)?
I'm frustrated!
Rob

 

[larryww]

Sorry that I don't have your requested solution, but this may be tangentially useful to you. It prevents the *annoying* virus scan on office products, that nearly (if not actually) hangs the loading of some files.

Regsvr32 /u "C:\Program Files\Norton AntiVirus\Officeav.dll"

This comes from Q243579

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q243579