I was wondering whether there was a way to put a code in VBA that if an excel
spreadsheet is not used after a certian time eg 30 minutes then it closes the
spreadsheet but save prior to closing.

Thanks
Noemi

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