Hello,

I have a workbook (attached) that is a test for users at work. I would like to use a START button initiate a five minute countdown timer that is visible on screen. I would also like it to give a warning at one minute. When the timer runs out, I would like the macro to lock a specific range of cells. Also, is it possible to have the timer running while users input information in the test area cells inside the charts. There wouldn't be any other macros running while they entered, only after they were finished.

Here's the workbook showing the test and the page setup. I know how to lock the cells or just protect the sheet in a macro and I've looked up tons of pages and links on timers but can't find something specifically for what I need. tried a couple of the timer macros but none seem to do exactly what I need done. If anyone has the time and a solution, I would appreciate it. Thanks.

Lobeo

test.xls