workbook won't close when other workbooks are open

I have a workbook that refuses to close if any other workbooks are open at the same time. This workbook has a running clock in it. Here are the macros that run this clock:

Please Login or Register  to view this content.

I got this code online and I frankly don't really understand how it works, but it keeps a clock ticking steadily on one of the spreadsheets, and I need it to continue doing this. But now, when there are other workbooks open, this workbook will not close. Not only that, but if I try to close it, it runs through the code in the Workbook_Open sub! Thoughts? Is there another way to run a clock in a workbook that I could try instead? Is there a loop somewhere in here that I'm not closing correctly? Help, please!

Found the answer here: http://stackoverflow.com/questions/2...ication-ontime

Your modified module code is below. Nothing changed in ThisWorkbook.

Please Login or Register  to view this content.

I tried these changes. The clock works fine, but the workbook still won't close if another workbook is open. If it is the only workbook open, it closes just fine, but I can't ask the people using this workbook to close all other workbooks before closing this one.

It works for my computer, so I thought it should be fine for you. Try replacing this code to add a delay before closing the book:

Please Login or Register  to view this content.

That worked. Thank you!