Issue With Macro Sheduling Using On Time Event

Can Excel Be a Complete Office Solution for Data Handling

  • It Can't Be

    Votes: 0 0.0%
  • Yes It Definitly Can

    Votes: 0 0.0%
  • Not Sure

    Votes: 0 0.0%

  • Total voters
    0

SumeshThomas

New member
Joined
Mar 26, 2013
Messages
1
Reaction score
0
Points
0
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.

Issue:

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. :ear:
 
Top