VBA / Generic Virus detected

[Emjaye]

Hi

Using Windows & Excel XP in conjunction with McAfee VirusScan on the agency network.
In my WB in question I have VBA which strips VBA from a worksheet under certain conditions (i.e. when the worksheet is COPIED) and writes in 1 remark line.
However the McAfee VirusScan catches it as a virus when the workbook is either saved or closed... (when the worksheet is not being copied)... with the message of "Detected: VBA/Generic // Type: Virus // Status: Cleaned"

The VBA "strip" code is placed in its own module, not in a WB or WS event, and nor is it called automatically, the user needs to press a button on the worksheet to activate the routine.

It's more of an annoyance than anything critical, however I would like a way to stop the over zealous Viruschecker catching the WB, which is virus free (checked with other Viruscheckers at home) everytime is is saved or closed.

 

[Joe Was]

Remove any Standard Module, like: Module1

You cannot remove Sheet Modules, or ThisWorkbook Modules, but you can remove any code from them. Slso UserForm Modules need to be cleaned of code.

If any of the above remain you will get that message!

No-Way around this, if there was everyone would use it to pass viruses.

If Excel is flaging your code then write a Self-Certification.