Macro triggers Virus Scanner

[PT]

I use WinXP Home, Excel 2003, and Norton I/N Security.

Several years ago, I created several macros, and associated toolbar buttons
to perform some common tasks: formatting cells for dates, decimal, whole
numbers, and inserting and adjusting column widths. They've functioned
flawlessly until today. Today.when I click any of these buttons, I get this
message, headed with an Excel banner:

"The file cannot be opened because your virus scanner has detected a problem
with the file"

I have no idea what I did to cause this. I haven't made any changes either
to the macros or to the Norton I/N security.

Any ideas?

 

[Harlan Grove]

flawlessly until today. Today.when I click any of these buttons, I get
this message, headed with an Excel banner:

"The file cannot be opened because your virus scanner has detected a
problem with the file"

I have no idea what I did to cause this. I haven't made any changes either
to the macros or to the Norton I/N security.

....

You may not have made any changes to your AV software you're aware of, but
is it set up to download updates automatically? You may want to check the
date stamp on the AV definitions file or check its installation log.

Anyway, your AV software should provide an interactive shell in which you
can see what it thinks is wrong with your .XLS file(s). It should also allow
you to recover the file so you could use it again. You could also set it up
to skip those files on subsequent scans.

OTOH, maybe your files were infected yesterday. Your AV software should be
able to let you know that, and it might be able to clean them if they were
infected.

 

[PT]

The problem isn't with an Excel worksheet file. It's with the Excel program
itself. In other words, I fire up Excel and open a new blank worksheet, the
homemade formatting macros produce the error message.

 

[PT]

Problem resolved by Norton. Tks

--
PT

The problem isn't with an Excel worksheet file. It's with the Excel
program itself. In other words, I fire up Excel and open a new blank
worksheet, the homemade formatting macros produce the error message.

 

[Randy]

I had this same problem. After about 2 hours on a tech support chat
session with Symantec, we finally resolved the problem. We did it via
the following steps (via Norton Internet Security 2007):

1. Open Norton Protection Center from the system tray (or Norton
Internet Security from Start | Norton Internet Security | Norton
Internet Security)
2. Click on the Norton Internet Security tab
3. Click on Settings | Auto-Protect | Configure
4. Under "Advanced Options", select Scan Exclusions
5. Click on New and add any files and/or extensions that Norton is
blocking.
6. Click OK and close Norton Protection Center

This worked for me. Hopefully, it will solve other's problems, too.

Good luck,
Randy