Sleeper: Lock the screen

[excelliot]

Is it possible to lock the screen when i'm off my computer(only excel window)
so that no one can alter it?:motz2:

[Steiner]

Your operation system should give you such an option to lock the whole computer. What should be the benefit of simply locking 1 single Excel instance? The user could always open a new one or shutdown the existing one as long as he has access to the computer and the operating system.

Daniel

[sheeeng]

Your operation system should give you such an option to lock the whole computer. What should be the benefit of simply locking 1 single Excel instance? The user could always open a new one or shutdown the existing one as long as he has access to the computer and the operating system.

Daniel

Argee..!:thumb

[johnske]

Is it possible to lock the screen when i'm off my computer(only excel window)
so that no one can alter it?:motz2:

Hi excelliot,

Try this kb entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=516) - there is a right-click menu option to lock instantly. (You can either delete the timer option if not wanted or just set the time to some ridiculously large value to effectively stop it cutting in)

Regards,
John

[Sir Babydum GBE]

If you really need to lock it with excel in view, do a screen print of Excel, set that image as your wallpaper, then lock your computer.

[excelliot]

Hi excelliot,

Try this kb entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=516) - there is a right-click menu option to lock instantly. (You can either delete the timer option if not wanted or just set the time to some ridiculously large value to effectively stop it cutting in)

Regards,
John

it closes whole ms - window and restarts comp
is it posiible not to close windows

[johnske]

Just comment out this line


Action = ExitWindowsEx(EWX_LOGOFF, 0&)

But unless you have the workbook password protected, there's then nothing to stop someone else altering it

[excelliot]

thanks let me try it

[mdmackillop]

Is this solved?