Stopping Application OnTIme when closing a workbook

Don't understand that because the timer process should be cancelled when the workbook closes. I would double check the Workbook_Open etc. to make sure that nothing starts when the workbook is opened.

The problem is that to stop the timer we need to know the exact time it was set for and have it stored in a variable. If you close the workbook, how is Excel to know this ? The only way to do this would be to save the value in a cell and save - and, as stated, this should not be necessary.

Here is some code :-

Please Login or Register  to view this content.