Timelaps

[Guest]

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

 

[mrice]

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.