VBA Macro to Stop PC from going to Sleep

[excelmatt]

Hello All,

For numerous reasons I am unable to prevent my screen from going to sleep during periods of inactivity. It is still being used to watch a live spreadsheet though. Is there a way I can write a macro to move the mouse, or do some action so that the pc thinks it is being used.

I am thinking of using some kind of timeserial command to press a button every 5 minutes or so. Would this work or do you know a better way?

Thanks,
Matt

 

[kevin lazell]

hi excelmatt
goto control panel
click the performance information and tools icon
click the adjust power settings
click the change when computer sleeps
in the drop down box select never
i am using windows 7 if you are not it will be something like the above
cheers

kevin