Timer for auto shut down

[Randy]

Iam using a macro as follows

Sub Timer()
Application.OnTime Now + TimeValue("00:10:00"), "savequit"
end Sub

I auto_open this and was trying to re-activate it with other macros
that are used in the spreadsheet so as long as there was activity the
above timer would be reset to the original TimeValue but it doesn't
work. Is there any way that the above timer can be reset with
different macros or a way to determine if there is no activity after a
predetermined amount of time that the spreadsheet saves itself and
closes the application.

Thank You in Advance
Randy

 

[Tom Ogilvy]

See Chip Pearson's page on Application.Ontime for an approach and sample
code:

http://www.cpearson.com/excel/ontime.htm