Timer for auto shut down
 

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

Timer for auto shut down
 

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

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

--
Regards,
Tom Ogilvy

"Randy" wrote in message
om...
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