Hello all,

When the Screen Saver is on, my macro run slow. Is it
possible to set the Screen Saver to None by Macro? How to
do it?

Thanks a lot!

Best Regards

Bill

Bill,

I don't know of a way to turn off your screen saver through code, but
I have heard that using sendkeys periodically prevents it from
starting up...

HTH,
Bernie


"Bill Li" wrote in message
...
Hello all,

When the Screen Saver is on, my macro run slow. Is it
possible to set the Screen Saver to None by Macro? How to
do it?

Thanks a lot!

Best Regards

Bill

Not a VBA solution, but one mwthod using the Windows API.

http://www.google.com/groups?hl=en&l...d84b45c&rnum=2

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
Hello all,

When the Screen Saver is on, my macro run slow. Is it
possible to set the Screen Saver to None by Macro? How to
do it?

Thanks a lot!

Best Regards

Bill