Swap to another worksheet after given time

Y

y_not

We have devised a simple Excel based test for new employees (only 16
questions). HR like it but have asked if it's possible to set some sort
of a timer so that 15 minutes after entering the first answer the screen
goes black (to end the test) and stop them entering any more answers.

Of course, after this happens we need to print of thier scores and
reset the answers for the next candidate.

Can anyone help, please?
 
L

Leith Ross

Hello y_not,

Add the following line of code to whatever starts your program. Excel
will run MyMacro (change this name to what you are using) 15 minutes
later. This would be your macro to blacken the screen etc.

Application.OnTime Now + TimeValue("00:15:00"), "MyMacro"

Sincerely,
Leith Ross
 
Top