software

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: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=533609