PDA

View Full Version : Close Workbook After Idle



Herbiec09
03-15-2018, 02:12 AM
Good morning All,

Would anyone be able to assist with a code that will automatically close a workbook and save changes once it has been idle for a certain amount of time, say 30 seconds?

Thank you

Herbz

GTO
03-15-2018, 02:30 AM
Have you looked through the Knowledge Base?

Try: Closing an Inactive Workbook (http://www.vbaexpress.com/kb/getarticle.php?kb_id=308)

Hope that helps,

Mark