Logging off / lock computer issue

[michud08]

Hello all,

I have a password protected workbook which people in the office use. The problem is this… when someone locks their computer with the database open, no one else can gain access, unless it is read only.

Is there a way for excel to recognise the “Ctrl alt del” command and execute a save and shut down of the spreadsheet before the computer locks? This will allow other users to then open excel and be able to read and write instead of read only.

Appreciate your time and thanks in advance

Cheers,

Mick

 

[Candyman8019]

It seems like it is possible...check out this thread. Determine if the computer is locked

You would probably want to check it on a specified interval.

 

[michud08]

I will have a look, cheers

It seems like it is possible...check out this thread. Determine if the computer is locked

You would probably want to check it on a specified interval.

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Database unavailable when computer is locked - OzGrid Free Excel/VBA Help Forum

Hello all, I have a password protected workbook which people in the office use. The problem is this… when someone locks their computer with the database open, no one else can gain access, unless it is read only. Is there a way for excel to recognise the…

forum.ozgrid.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.