View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 390
Default Run - time error '1004'

Hello,

I have a file with a code for blinking text.
At this moment I am entering some data in this file, so I click on macro in
the tool bar to stop the blink texts. The problem is that after I save the
file and come to close the file, a window appears with this error.

Run - time error '1004'
Method 'On Time' of object '_Application' failed.

Continue End Debug Help

When I click Debug, it is giving me these offending lines:

Application.OnTime RunWhen, "StartBlink1", , False
Application.OnTime RunWhen, "StartBlink2", , False
Application.OnTime RunWhen, "StartBlink3", , False
Application.OnTime RunWhen, "StartBlink4", , False

Any help please,
Thanks in advance.