Hi Friends,

I have created a macro enabled template for data entry purpose. There is a On Time Macro which schedules every 5 min and check if the system is locked and mark the next data entry row as user went inactive if computer is locked; else wont do any think; just shedule for next time after 5 min.


Problem is the user either try to leave the excel sheet in edit mode of just try to edit a protected cell which gives the usual protection error prompt; and then they lock the system in that state. This will stop the macro from running and marking user inactivity.

The purpose of the template is to control break of the employees who do those data entry.

Any solution for this drawback.