View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Perry Perry is offline
external usenet poster
 
Posts: 3
Default Run macro when excel workbook gains focus

On further observation, the OnTime method (I guess like all Methods)
does not remain, pending return focus to Excel if another application
is executed between start and scheduled time.

OnTime talks about waiting on a function completing and then the OnTime
function/macro running. This would appear only to be correct if Excel
remains the active application and has not been "deactiviated", to say,
check Outlook in the mean time.