see Chip Pearson's page on using Ontime
http://www.cpearson.com/excel/ontime.htm
you could combine this with a selectionchange event to cancel the currently
scheduled event and schedule a new one.
http://www.cpearson.com/excel/events.htm if you are not familiar with
events.
--
Regards,
Tom Ogilvy
"Jesse" wrote:
Can anyone point me to a reference for coding an idle timer? I have a
submission tool that multiple users access that I want to put an idle
timer on so that after a certain amount of time it gives a warning and
to long and it automatically closes the workbook.
Jesse