View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
luda luda is offline
external usenet poster
 
Posts: 4
Default VBA code slows to a snails crawl when screen saver activated

1. You may want to ensure that the XL-screen update is
done ONLY when it is indeed needed and script all the
other processes so that they are "behind the screen."
This means limit the use of Activate and Select methods.

2. Turn off the Automatic Calculation on the start of your
code and turn it on before exit. If you need to perform
recalculation of the sheet during the code-run, use
Calculate statement.

3. Make sure you are off the Internet and the connection
is shut down - that may stop the behind-the-screen
interactive activity and free up your resources.

4. You may want to re-examine the system settings of your
machine and assign larger paging memory-size.

5. You may want to look into hardware configuration of
your computer and make a few upgrades to optimize the
performance.

Changing the priority level does not seem to help much.

In any case,
Good luck.
Luda

-----Original Message-----
My firm has implemented a mandatory screen saver policy

to
prevent unauthorized access to PCs. Unfortunately, I have
VBA/Excel processes that use multiple spreadsheets, DDE
links and such in a daily process. Well, with the saver
activated the process slows to practically nothing. What
aspect of my programming is likely the bottleneck that is
slowing everything down? Assuming there is no ability to
deactivated the screensaver is there any way I can modify
my code so the saver doesn't slow it down?
.