You can probably do this with a combination of events (such as
Workbook_SheetChange, Workbook_SheetSelectionChange and
Workbook_SheetActivate) all linked to a macro calling the
application.onTime method.

The events would trigger the restarting of the clock which will cause a
save followed by a close after your chosen length of time.


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533609