Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I'm drafting a macro by which I want to repeat at intervals of 59 secs another macro 'TimedOut' so have: Application.OnTime Now + TimeValue("00:00:59"), "TimedOut" which works fine. Except even if the worksheet is closed, it reloads itself and continues [until Excel is closed]. The MS help and the textbooks say add a line with the same text but ending False ie Application.OnTime Now + TimeValue("00:00:59"), "TimedOut",False but that seems to have no effect. Grateful for any suggestions *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find %ontime & SUMIF ontime ie: find matching sets within Range... | Excel Worksheet Functions | |||
OnTime bug? | Excel Discussion (Misc queries) | |||
OnTime | Excel Programming | |||
about ontime | Excel Programming | |||
OnTime Help | Excel Programming |