Imbedding an auto-update Clock in excel

A

a_ndy2003_uk

-Im trying to imbed a clock in an Excel sheet that will automaticall
update both hours/minutes/seconds. Any ideas???-

- The date was straightforward... -

Thanks,
And
 
A

a_ndy2003_uk

Thanks for the help guys! I took Harald's code, pasted it into a module
then ran:


Public Sub Auto_Open()

Sheets("Control Panel").Select

Application.Run "clock"

End Sub


And it worked!

Thanks agai
 
A

a_ndy2003_uk

Although it is working, when i close the workbook, it automaticall
re-opens the workbook!! very strange!!

Module1:

Public Sub Auto_Open()
Sheets("Control Panel").Select
Application.Run "clock"
End Sub

Module2:

Sub clock()
ActiveWorkbook.Worksheets(1).cells(1, 1).Value = _
Format(Now, "hh:mm:ss")
Application.OnTime (Now + TimeSerial(0, 0, 1)), "clock"
End Sub

I made the Application.Run "clock" code in Module1 a comment and i
stopped so its definately that.

Any ideas
 
H

Harald Staff

Any ideas ??! !??
Why do you think the clock macro starts with
If stopit = True Then Exit Sub
and why did you remove it ?

Best wishes Harald
 
Top