Active Clock

[richblake74]

Is there anyway of getting an "Active Clock" in a cell.
I know the =now() thing, but this is not what I am looking for,
I would like to get a clock that updates by the minute, without having to select a cell, or make excel do a calculation.
Hope you are all having fun with excel 2007
richblake74

 

[erik.van.geit]

Sounds like you have an extra excel.exe running. Well... Two is better than one. Right?

That's a joke to tell me you don't know eighter or ...?
I hope you believe me this really happened

only thing I did:
Restart computer & open file
Still same problem...

tried over and over, then
Deleted code within sub "Tick", saved, closed, opened again, restored code, now running OK

This will probably remain a mistery for ever.
kind regards,
Erik

 

[Legacy 98055]

I don't really know Erik. For whatever reason, when you open Excel, there are actually two processes that start. Two Excel.exe. One of them closes almost immediately. I have no idea what the second one is for. Maybe using a timer keeps it open? I have no idea...

 

[glerwell]

Can anyone help me?

Im having trouble getting the macro to eun when I open / run the worksheet.

thanks

 

[stockgoblin42]

Re: active Clock

Yes

Right click the Excel logo just to the left of File on the menu and select View Code. Paste in the following

Private Sub Workbook_BeforeClose(cancel As Boolean)
Call StopClock
End Sub

then close the code window. When you close the workbook the timer will stop.

Hi!

Thanks for this info. I'm doing the same thing but with Excel 2010 - There's no "View Code" when right clicking the logo anymore. Where do I put this code?

Thanks for any help

 

[VoG]

Re: active Clock

Press ALT + F11, in the Project window double click ThisWorkbook then paste in the code.