Automatic Save & Close after 30 min of inactivity

[dickharlo]

Is this easy to setup? I see options for backup save....but I need
the open file to save and close if inactive for 30 minutes.

Thanks!

 

[Thomas [PBD]]

dickharlo,

Check this attachment from the ozgrid forums. This one is set to 10
minutes. You can change it in the Workbook_Open function at the top. Note:
you will have to copy the VBA script from the Module2 and ThisWorkbook module
into your book.

http://www.ozgrid.com/forum/attachment.php?attachmentid=10100&d=1132326905