Hi Bob,

I have done intensive work on this issue.

I know how it is suposed to be done but it just does not work. It is a bug,
an annoying one.

Again, try closing a workbook with a live On Time procedure from a different
workbook, if you rely on the Before_Close event it does not work. It never
works.

You have to call the kill timer sub independently and it does not always
work.

"Bob Phillips" wrote:

You should kill the timer. Chip Pearson explains it all on
http://www.cpearson.com/excel/ontime.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Antonio" wrote in message
...
Hi Excelent,

I have been looking at your code.

Since you have worked with the Application On Time command I wonder if you
have run into the following difficulty:

If you try to close the workbook that has the timer running from another
workbook, programatically, the Before_Close event will run the Stoptimer
but
it won't kill it. It will refire again.

This has caused me ample problems.

Try it
"excelent" wrote:

Maby u can use this as inspiration

http://pmexcelent.dk/FileMaster.xls