Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro triggers Virus Scanner
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? -- PT |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro triggers Virus Scanner
"PT" wrote...
.... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro triggers Virus Scanner
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 "Harlan Grove" wrote in message ... "PT" wrote... ... 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro triggers Virus Scanner
Problem resolved by Norton. Tks
-- PT "PT" wrote in message ... 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 "Harlan Grove" wrote in message ... "PT" wrote... ... 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. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro triggers Virus Scanner
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro that triggers off a combo box | Excel Discussion (Misc queries) | |||
Macro virus | Excel Worksheet Functions | |||
how do I turn off Virus Scanner? | Excel Discussion (Misc queries) | |||
Can't open any files due to my non-existant virus scanner | Excel Discussion (Misc queries) | |||
virus scanner has blocked this file | Excel Discussion (Misc queries) |