Thread: OnTime problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Pantus Peter Pantus is offline
external usenet poster
 
Posts: 16
Default OnTime problem

Please any help,

Im using XP and Excel 2000
When I run StopTimer() and I close the workbook, the workbook opens itself.
When I delete the On Error Resume Next line I get a error message "Methode
OnTime van object_Application is mislukt"
Can anyone tell me what I'm doing wrong??

Sub StopTimer()
On Error Resume Next
Application.OnTime earliesttime:=RunWhen, _
procedu=cRunWhat, schedule:=False
End Sub