Auto Close if inactive for set time

[pauluk]

Is there a way to automaticly close a sreadsheet if it has been inactiv
for 10 minutes

 

[Tom Ogilvy]

Look at Chip Pearson page on using Application.Ontime

http://www.cpearson.com/excel/ontime.htm

There is no built in way to do it. You would have to use the change event
to cancel the current ontime event (to close the workbook) and schedule
another one 10 minutes hence. If the change event didn't fire in 10
minutes, then the time would be reached and the macro assigned to the ontime
event would be fired and close the workbook.