Macro won't run if text is being edited in cell

I have a log book that gets modified through out the day, and an auto run macro that runs at specific times to save the data to a database type sheet, and clear the form for the next shift. some of the operators are double clicking in the cell so they can type their comments. If they do not hit tab or enter when they are done, and the save time comes, the macro is not running, and I'm not collecting the data that I need. Is there a way to force the macro to run, or to force a tab/enter after 3 minutes of inactivity?

You could set a timer after the sheet opens....
Run a procedure to save, then your other app can run.

Please Login or Register  to view this content.

This is a similar code to the one that is running my database and clear macro the problem is this sheet stays open all the time, and if the operator leaves the cursor in the cell the macro will not run .ontime