Thread: OnTime
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gordon Humphreys[_2_] Gordon Humphreys[_2_] is offline
external usenet poster
 
Posts: 12
Default OnTime


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 ***