PDA

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



Erdin? E. Ka
05-03-2007, 05:26 AM
Hi everyone,:hi:

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. :doh:

Can someone help me please?

Thanks in advance.

johnske
05-03-2007, 05:35 AM
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
05-03-2007, 06:27 AM
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, :hi:

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. :friends: