How to lock computer using VBA

Question

How to lock computer using excel VBA? Just in case, by "lock computer" I mean same effect when you do "start menu --> shutdown --> Lock".

Sorry, it is a duplicated one. "Simulate windowskey+L in visual basic" solves this qeustion as brettdj suggested. — RealLifePM, Jun 14 '16 at 07:36

score 1 · Accepted Answer · answered Jun 14 '16 at 07:35

1

For a x64 bit:

Option Explicit

Private Declare PtrSafe Function LockWorkStation Lib "user32.dll" () As Long

Private Sub LockStation()
    LockWorkStation
End Sub

For x32 bit:

I think it's like this, can't test as I don't have a 32bit pc.

Option Explicit

    Private Declare Function LockWorkStation Lib "user32.dll" () As Long

    Private Sub LockStation()
        LockWorkStation
    End Sub

Happy coding.

answered Jun 14 '16 at 07:35

James Heffer

686
1
6
17

Thanks a lot. James! – RealLifePM Jun 14 '16 at 07:43
No problem RealLifePM, VBA is rather fun. – James Heffer Jun 14 '16 at 07:44

How to lock computer using VBA

1 Answers1