Look at Chip Pearson's page on using Application.Ontime
http://www.cpearson.com/excel/ontime.htm
also, past postings on this topic
http://tinyurl.com/qaysq
--
Regards,
Tom Ogilvy
"PRAV" wrote in message
ps.com...
Hi, is there a way to save and close automatically an excel spreadsheet
if it
has been inactive or has not been keypressed for one hour. Thank you.