Excel reopens workboog after closing it.

[Fred Flintstone]

I have a macro that uses ontime to recalc two ranges, within two workbooks
every 60 seconds.
When I run this macro, even it I cancel the ontime using the ,false
argument, if I close the workbook, the workbook re-opens.
If I close the second instance, without having started the macro, It does
not re-open.

Does anyone know, is there a way to see if ontime has anything scheduled?
Does anyone know why this might be happening?

I had a similar situation long time ago, where I used msquery to use an sql
statement to get specific information from a table wihin the workbook I was
currently using.
Whenever I ran the query, then closed the workbook, the workbook would
reopen.
I don't know if these are related as the functions are different, but the
simptoms are the same.

 

[Dave Peterson]

I don't think you can know if .ontime has anything scheduled.

And my guess (only a guess) is that you had multiple procedures scheduled and
only canceled one of them.

You could always close excel to kill all pending scheduled procedures.

(I don't have a guess about the SQL example.)

If you haven't looked at Chip Pearson's notes about OnTime, you may want to
review them:
http://www.cpearson.com/excel/ontime.htm

Maybe you'll see something important???