Thread: Loop with Time
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
 
Posts: 695
Default Loop with Time

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