Need Help Using Windows Timers

Greetings, I have a WB that is used among my department. If one user 'forgets' to close the WB, it locks everyone else out. I've tried using a SHARED WB, but that has lead to other issues, and from what read, it's just as well that I don't use a SHARED WB.

To my point...I was given reference to http://www.cpearson.com/Excel/OnTime.aspx and have attempted to use the provided example. When I use the line of

Please Login or Register  to view this content.

the entire Excel application gets closed. I only want to close the WB, in case the user has other WB's open, I don't need to disturb them.

Here's the code I have, no other code is in the WB.

Please Login or Register  to view this content.

You help is appreciated...

I have Excel 2003 and can use ThisWorkbook.Close to close only the workbook and not the application.

As a test, can you run this macro with a new workbook.

Please Login or Register  to view this content.

Yes, that line of code does work, but when you put it together with the rest of the code, the TimerProc is killing my Excel application too.