Excel - Automatic Save and Close (if inactive)

[SoledWorker]

Is it possible to detect inactivity and then save/close an excel spreadsheet after a (timeout) period? Application is a shared spreadsheet that will become (essentially) locked if a user forgets to exit.

 

[bacon4life]

The first link has an attachment that may do it, but I was a bit hesitant to download it. The second link shows you how to detect the idle time, you just need to add the save and close functionality.

http://www.ozgrid.com/forum/showthread.php?t=42651

http://www.freevbcode.com/ShowCode.asp?ID=3297

 

[Clyde38]

From "ExcelTips Daily Nuggets"

http://excel.tips.net/Pages/T002281_Automatically_Closing_a_Workbook.html