Running Clock to show PC time, but starts from 00:00:00

Hello again wizards!

Sorry, third request in about 48hrs from me. Hopefully this is a quick one.

I've got a bit of code to show a running clock, called by Worksheet_Open. This works, but the clock always starts from 00:00:00, where I would like it to display the time as used by the PC. Oddly enough, if you go into VBA and manually reset the project, when you go back to the Excel worksheet, it does actually display laptop time correctly!

Would appreciate it if one of you lot could cast your eye over it.

Please Login or Register  to view this content.

You're right. I am going to kick myself. Severely, and repeatedly.

I copy>pasted the code from a lap timer, and completely missed the bit where I change it back to a clock!

Oh well, an easy fix is good! Thanks for the sanity check!