View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Amedee Van Gasse[_3_] Amedee Van Gasse[_3_] is offline
external usenet poster
 
Posts: 102
Default How to use VBA to copy this code to "thisworkbook" objects of all opened workbooks ?

Amolin shared this with us in microsoft.public.excel.programming:


Thank you, I have Symantec Anti _Virus installed.


Which is no guarantee. I experienced the problem with McAfee, but other
AV may do the same. Perhaps not now but who knows about future versions?

The problem is with .InsertLines (and also with .DeleteLines). Some
macro viruses use this to add their own code to other workbooks. So a
proactive AV may not know the virus yet, but it sees the .InsertLines
activity and it say, better safe than sorry.

If you have a standalone AV, you can perhaps disable this particular
scanning feature. With a managed or network scanner: don't know,
perhaps not.

In My Humble Opinion it is important that not only you know there can
be a problem, but also WHY there can be a problem. That way you can
work around it.

--
Amedee Van Gasse using XanaNews 1.17.4.1