Swap to another worksheet after given time
 

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?


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=552884

Swap to another worksheet after given time
 

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=552884