S
SumeshThomas
Hi Friends,
I have created a macro enabled template for data entry purpose. There i
a On Time Macro which schedules every 5 min and check if the system i
locked and mark the next data entry row as user went inactive i
computer is locked; else wont do any think; just shedule for next tim
after 5 min.
Issue:
Problem is the user either try to leave the excel sheet in edit mode o
just try to edit a protected cell which gives the usual protection erro
prompt; and then they lock the system in that state. This will stop th
macro from running and marking user inactivity.
The purpose of the template is to control break of the employees who d
those data entry.
Any solution for this drawbac
I have created a macro enabled template for data entry purpose. There i
a On Time Macro which schedules every 5 min and check if the system i
locked and mark the next data entry row as user went inactive i
computer is locked; else wont do any think; just shedule for next tim
after 5 min.
Issue:
Problem is the user either try to leave the excel sheet in edit mode o
just try to edit a protected cell which gives the usual protection erro
prompt; and then they lock the system in that state. This will stop th
macro from running and marking user inactivity.
The purpose of the template is to control break of the employees who d
those data entry.
Any solution for this drawbac