Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active Workbook | Excel Discussion (Misc queries) | |||
Store Active Workbook | Excel Discussion (Misc queries) | |||
Active Workbook online. | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
run a macro on an in-active workbook | Excel Programming |