VBA strange behavior On time events firing at unexpected time intervals.

Slowly getting there with VBA but something i've (had help) written isn't behaving as it should, i'm struggling to understand why?

THIS WORKBOOK CODE

Please Login or Register  to view this content.

MODULE CODE

Please Login or Register  to view this content.

SHEET LEVEL CODE

Please Login or Register  to view this content.

EXPECTED BEHAVIOR:
after 14 minutes and 30 seconds inactivity within the workbook a userform should pop up with a 30 second countdown asking the user if they still need the workbook open. a YES response starts a 4 minute 30 second countdown where the same userform is presented, a NO response or a timeout results in the workbook saving and closing. (need to reliably ensure this happens even if the workbook isn't the active application taking focus somehow)

ACTUAL BEHAVIOR:
userform is presented after a few seconds with the 30 second countdown, and re-presented a few seconds later when YES button clicked.

GRRR!!!

I've tried implementing your idea which sounds like it should solve the problem, i think I've done it poorly as I've made the situation far far worse. (Thankfully i've the code saved here so I can fix it).

I have the file closing itself after a few seconds or even after I press Yes in the userform (which should have given me 5 minutes).

I have literally spent 3 days on this and seem to only make things worse rather than better - if anyone could take a look at this and provide the code to show what i'm doing wrong - you'd be saving me one helluva migraine.

Thank you

shameless bump, please help restore my sanity

worked like a charm thank you.