Solved: How To Automaticly Close A Workbook If Nothing Changed In 15 Minutes?

[Erdin? E. Ka]

Hi everyone,

I'am trying to write a macro for automaticly close a opened workbook if nothing changed in 15 minutes in the workbook?

I researched about Application.OnTime but i couldn't solve it.

Can someone help me please?

Thanks in advance.

[johnske]

http://vbaexpress.com/kb/getarticle.php?kb_id=516 could be modified to suit - you can use the Application.Ontime examples anyway...

[Erdin? E. Ka]

http://vbaexpress.com/kb/getarticle.php?kb_id=516 could be modified to suit - you can use the Application.Ontime examples anyway...

Hi John Skewes,

Actually i am not clever enaugh for modified your project to my project, but i used totally your project.

Thank you very much to kindly help. Take care.