nope cant say i have, i made this sheet for another, he newer told me of any
problems. Anyway i use this code to stop timer
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopTimer
End Sub
"Antonio" skrev:
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