VBA code slows to a snails crawl when screen saver activated

S

Stephen Bain

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?
 
M

Marshall

I am not sure about the code itself, however if the screensaver is an
OpenGL Screensaver, then the screensaver itself is probably the
problem. OpenGL screensavers generally try to take up as much of the
processing power that the cpu has available and this could slow down
your process considerably.


Try switching to a non-opengl screensaver, or turning the effects down
on the one that you have.



If this isn't the problem, I unfortunately do not know what about your
code itself would be causing the problem.
 
L

luda

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
 
Top