Database unavailable when computer is locked

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    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? I already have VBA code to save the database when you close it, so just need a bit of code to recognise the "ctrl alt del" input and from that I can call a sub. 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[Blocked Image: https://cdn.jsdelivr.net/joypixels/assets/6.6/png/unicode/64/1f44d.png]

    Cheers,

    Mick

  • rory

    Added the Label Cross Post

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!