Thread: Active workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Wolf[_2_] Jack Wolf[_2_] is offline
external usenet poster
 
Posts: 2
Default Active workbook

Is there a way to tell if the workbook containing a macro
is the active workbook? I am calling a subrouting using
Application.OnTime (and calling itself in another interval
until it is stopped by using the Scheduled argument in
another OnTime call) but I would like it to do something
different if the workbook is not active. I know that the
macro continues to call itself if another workbook is
active or even if another application is active.

Thanks
JW