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

--
Message posted from http://www.ExcelForum.com