Issue With Macro Sheduling Using On Time Event

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top