One way described he-

http://www.ozgrid.com/forum/showthread.php?t=32949

Mike

"Steve" wrote:

Is there a way to save and close a spreadsheet when there has been no
activity for a particular amount of time? We have a problem with several
users needing access to the same workbook.
Thanks