Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shut off web links? | Excel Discussion (Misc queries) | |||
Ignoring code to shut a workbook if it is already shut | Excel Discussion (Misc queries) | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
GETPIVOTDATA -- How do I shut it OFF! | Excel Worksheet Functions | |||
Shut down excel | Excel Discussion (Misc queries) |