Inactivity Timer

[LSM1604]

Hey all,

I was wondering if anyone could help me with an inactivity timer within my workbook? I already have some code which runs when the workbook is closed:

module1.SaveClose_Click

What I would like is the aforementioned procedure to run when the workbook is inactive for 20 minutes. This could be done by either of the following:

• The mouse has not been moved.
• There has not been a cell selection change or a macro has not run.

Many thanks,
LSM1604

 

[Warship]

Have a look at
http://www.cpearson.com/Excel/OnTime.aspx

 

[LSM1604]

Hi Warship,

Thanks for the reply, one problem though, I don't understand the information on the link you posted. Where do I put the code? How does the timer start upon cell selection or mouse movement?

Thanks,
LSM1604

 

[LSM1604]

Could anyone help with this please?

Thanks,
LSM1604

 

[LSM1604]

Any ideas anyone?

I will be very grateful if somebody could help me out pleasE?

LSM1604

 

[Warship]

Look at:
http://www.cpearson.com/Excel/TimedClose.htm

 

[Jaafar Tribak]

You may also want to take a look at the last post HERE by Tom Schreiner which caters for all mouse and keyboard inactivity.

 

[LSM1604]

Works perfectly, thanks everyone :D