Stopwatch Macro

[viveknath]

Hi,

I've created a stopwatch using this (https://www.extendoffice.com/documen...stopwatch.html) tutorial and it works perfectly.
I would like to add another function to this.
Is it possible to automatically stop the timer when the screen locks and start the timer automatically when we unlock the computer?

Regards,
Vivek Nath

[Stormin']

You can use the following code to check if your system is Locked or Unlocked (I just checked it and it works). Incorporate it into your timer and you can achieve the function you want.

Code credit (https://www.mrexcel.com/forum/micros...using-vba.html)

Please Login or Register  to view this content.

[ranman256]

I got it to stop upon screen lock, but you must manually restart after you unlock:
the variable: gbWasRunning ,was to detect if you were actually running the timer at lock. If unlock and running, then restart, but nothing tells excel to look after unlock.

Please Login or Register  to view this content.

[viveknath]

I tried your code but it seems not working.
Timer is not starting when I click on Start button.