Thread: timer Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Puzzled
 
Posts: n/a
Default timer Macro

Looking for help in making a stop macro the below timer macro
Timer works but seems to continue running

Public Sub timer1()
Application.OnTime Now + TimeValue("00:00:5"), "stop1"
End Sub

Thanks Leon