Hi, I'm working on a project to update production notes in a manufacturing schedule. I've written a macro (Open_SFCDB) to pull in the data to the manufacturing schedule and I'm using the "Application.OnTime" event (RunWhen2) to run the macro every 5 mins. I also have additional VBA code (SaveAndClose) to close out the workbook if a User has it open without any activity after 90mins using another Application.OnTime" event (RunWhen). This code is all in the "This Workbook" object
However my problem is that when a User closed the workbook, it "automatically" opens again after 5 mins !! I'm "trying" to use the "BeforeClose" events (BeforeClose & BeforeClose2) to close out both ontime events but I'm obviously doing something wrong
A point that may also be relevant is that this will be a "shared file" on Excel 2010.

I'm pretty new to VBA so any assistance with the code would be much appreciated as this is really "wrecking my head". The code I'm using is below:

This Workbook Object:
Please Login or Register  to view this content.
'Open_SFCDB' Code (Module8)
Please Login or Register  to view this content.
RunWhen Code:
Please Login or Register  to view this content.