ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to control screen saver (https://www.excelbanter.com/excel-programming/313388-macro-control-screen-saver.html)

helmekki[_25_]

Macro to control screen saver
 

Hi all

Is there a macro, i can call it any time i want, to force screen save
to start and password prompt to cancel it ?

i know widows does the job on interval bases...but i want to call i
whenever i leave my computer, so cannot anticipate when i will leave m
computer...

any help is realy appreciated...............
yours
h :

--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=26881


Bernie Deitrick

Macro to control screen saver
 
helmekki,

Your path may be different: find where OSA.EXE resides on your machine.

Sub RunScreenSaverProgram()
program = "C:\Program Files\Microsoft Office\Office\OSA.EXE -s"
TaskID = Shell(program, 1)
End Sub

The password setting is controlled by the usual routine: properties from the
desktop.

HTH,
Bernie
MS Excel MVP

"helmekki" wrote in message
...

Hi all

Is there a macro, i can call it any time i want, to force screen saver
to start and password prompt to cancel it ?

i know widows does the job on interval bases...but i want to call it
whenever i leave my computer, so cannot anticipate when i will leave my
computer...

any help is realy appreciated...............
yours
h :)


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:

http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=268819





All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com