Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to disable screen saver
In Excel2000, I would like to have a macro that will do something every
14 minutes in order to stop the screen saver and logout from popping up. It is a work PC and the screen saver and logout are defaulted by the netork to go on every 15 minutes. I was thinking of something like: SendKeys ENTER but I don't want to use ENTER because I want the macro to run another macro that runs my reports and using the ENTER may make my other macro not run correctly if every 14 minutes Excel is hitting enter. Is there a way to sendkeys without sending anything just so that it interupts the screen saver and logout procedure? THanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to disable screen saver
snax,
Talk to your system admin about getting an exception to the policy, so that you can turn off your screensaver. HTH, Bernie MS Excel MVP "snax500" wrote in message ups.com... In Excel2000, I would like to have a macro that will do something every 14 minutes in order to stop the screen saver and logout from popping up. It is a work PC and the screen saver and logout are defaulted by the netork to go on every 15 minutes. I was thinking of something like: SendKeys ENTER but I don't want to use ENTER because I want the macro to run another macro that runs my reports and using the ENTER may make my other macro not run correctly if every 14 minutes Excel is hitting enter. Is there a way to sendkeys without sending anything just so that it interupts the screen saver and logout procedure? THanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to disable screen saver
They said no.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to disable screen saver
"snax500" wrote in message ups.com... In Excel2000, I would like to have a macro that will do something every 14 minutes in order to stop the screen saver and logout from popping up. It is a work PC and the screen saver and logout are defaulted by the netork to go on every 15 minutes. I was thinking of something like: SendKeys ENTER but I don't want to use ENTER because I want the macro to run another macro that runs my reports and using the ENTER may make my other macro not run correctly if every 14 minutes Excel is hitting enter. Is there a way to sendkeys without sending anything just so that it interupts the screen saver and logout procedure? THanks Havent played with SENDKEYS within Excel nor real-time countdowns within, but presume you specify which window/application to SENDKEYS to as per vbscript...so point the "cursor" somewhere safe (say Notepad) before sending the keystroke every 13-minutes then returning to Excel should proceed without disrupting the report?? Alternately, search your local driver for either/both wscript.exe or cscript.exe to see if Windows Scripting is avaiable, and if so, entertain the Screensaver there so Excel can process the report without distraction. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro as Screen Saver | Excel Discussion (Misc queries) | |||
Macro to control screen saver | Excel Programming | |||
Excel cannot complete ......... when screen saver is activated. | Excel Programming | |||
XP Screen Saver | Excel Programming | |||
Turn off Screen Saver by Macro | Excel Programming |