Turn off Screen Saver by Macro
 

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

Turn off Screen Saver by Macro
 

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

Turn off Screen Saver by Macro
 

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