Hello

i user this code for timer in my excel
'                                                TIMER CODE START
Option Explicit

Dim StopTimer           As Boolean
Dim SchdTime            As Date
Dim Etime               As Date
Const OneSec            As Date = 1 / 86400#

Sub ResetBtn_Click()
    StopTimer = True
    Etime = 0
    [Time].Value = "00:00:00"
End Sub
Sub StartBtn_Click()
   StopTimer = False
   SchdTime = Now()
 On Error Resume Next
   [Time].Value = Format(Etime, "hh:mm:ss")
   Application.OnTime SchdTime + OneSec, "NextTick"
End Sub

Sub StopBtn_Click()
    StopTimer = True
    Beep
End Sub

Sub NextTick()

   If StopTimer Then
      'Don't reschedule update
   Else
   On Error Resume Next
      [Time].Value = Format(Etime, "hh:mm:ss")
      SchdTime = SchdTime + OneSec
      Application.OnTime SchdTime, "NextTick"
      Etime = Etime + OneSec
   End If
   
    
End Sub

'                                                 TIMER CODE END
and StartBtn_Click in workbook open sub

if i save and close the file, when i open it the timer start from zero
how can i keep it continue ?

thanks