This is so weird to me. We run a macro to update information in 60 cash files each day. We'd had problems with people leaving their cash sheet files open, which kept them from being updated, so I put a timer in each of the files that launches a message at 4:29pm that the file will save and close automatically at 430pm. The weird part is that if you open one of these files at any time during the day, close it and do not open it again, the message will still pop up on your screen at 4:29pm AND you'll find the same file you opened earlier is now open on your desktop! All of the coding was cobbled together, so my ability to analyze it is limited. Also, we are on a network, and I wonder if that has something to do with it. Any thoughts would be appreciated. Here's all the coding I added to the file:
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks