Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default Macro Speed and Virus Scanner Installed.

I have a fairly involved macro I use at work, (It does some sorting and row
deletes and row inserts and calculations), and it takes about 7 seconds to
complete. I took the file home. I have a Pentium 4 with Excel 2002. The
same macro takes 1 minute to process. On my home computer on the Tools /
Macro / Security I have it set to low but I did notice down at the bottom
left corner of the dialog box it also says "Virus scanner installed" but at
work it does not have this. Also every time I open a file at home containing
macros the status bar says Requesting Virus Scan even thought the Security is
set to low and this makes the files take about 5 times longer to open than at
work. What is going on here? Is there an extra layer of virus protection on
my home computer that is causing this? How do I remove it? I have Norton
virus protection on the computer at home if that might also make a difference.

Thank you for your help.

Steven
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro triggers Virus Scanner PT New Users to Excel 4 June 21st 07 12:42 AM
how do I turn off Virus Scanner? Techware Excel Discussion (Misc queries) 0 August 1st 05 02:04 AM
Can't open any files due to my non-existant virus scanner Jay Excel Discussion (Misc queries) 1 July 3rd 05 07:54 PM
virus scanner has blocked this file nishak Excel Discussion (Misc queries) 1 June 24th 05 05:48 PM
How do I Remove Virus Scanner nowhereman[_2_] Excel Programming 3 August 10th 04 11:24 PM


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"