When ever Word or Excel is opened and error message "Microsoft Visual Basic" "code execution has been interrupted" the the options continue or end are available.
Something like this is usually an indication of a macro that does not work properly. That could mean a virus as well. To check, I'd first rename normal.dot. Make sure there are not more than one instance of normal.dot on ur system.
this doen't take care of the Excel problem. for that, try to see if there is anything in the Excel startup folder. hard for me say where it would be located since I don't the OS ur using.
I disagree with cheerio to the extent that I would remove the word VIRUS from his first sentence and because, since 97, most macros will run in the 3 most recent versions. Just because a macro fails does not make it a virus.
There are many programs these days that install themselves into the Office Suite and you're not warned:
You are probably right that it is an add-in or AV problem.
However, I disagree with your comment that most macros will run across most versions. That will be true for someone as clever as you because you will know how to avoid the problems. However, try running VBA code created in Office 2000 that uses the Enum statement in an older version. What about the endless problems caused by code written for DAO being misunderstood as ADO?
The fact is that many less knowledgeable people do write code that does not run properly across Office versions. That includes sloppy commercial code and some poorly written viruses.
If the problem is a virus then it needs to be dealt with before harm is done. Once you know it is not a virus you can then look at installed add-ins.
I must agree with Anne that it is not a virus. Macros that cause errors stop running because of the errors, and a Macro Virus that doesn't run can't spread, meaning it is no longer a Virus.
And it is true that _most_ macros run across all three recient versions. There are some, however that do not work properly on different versions, either direction (older macros that don't run on newer versions of Office as well as newer macros that won't run on older versions of Office.)
I'd try removing the addins before I'd panic about a virus. When both Excel and Word are having a problem, this is often caused when a program is uninstalled and the program didn't remove it's Office addins. Check out the startup folders.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.