On time kill

Giganews Newsgroups
Subject: On time kill
Posted by:  Antonio
Date: Wed, 7 Jun 2006

I have the following code that runs every minute

Application.OnTime Now + TimeValue("00:01:00"), "max_min"

I want to cancel that OnTime schedule in the Before_Close event.

How can I do that. I am having difficulties with the EarliestTime

Application.OnTime EarliestTime:=Now+TimeValue("00:01:00"),
Procedure:="max_min", Schedule:=False

does not work

If I don't kill the call to max_min the spreadsheet keeps opening up or
causing errors when it is opened.

Thanks,

Antonio

Replies