Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
<Pass the Torch from a Closing Workbook
All,
I am working with two workbooks, wbA and wbB. wbA opens wbB. wbB does some work interactively with the user, then the user closes wbB with a button on a modeless userform uaing the statement "ThisWorkbook.Close". I wish wbA to detect that wbB is now closed and to continue its work.(e.g.: Show a userform in the context of the file which was just exited). The Problem: If the user closes wbB manually, wbA WorkbookActivate event is fired. (This is good) If the ThisWorkbook.Close command is initiated in wbB itself, no WorkbookActivate event is triggered when wbB closes . It becomes impossible to detect, from wbA, that wbB is closed (This is bad). Any suggestions? Thanks for your help, Alex J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing a workbook | Excel Discussion (Misc queries) | |||
pass variable from one workbook to another | Excel Discussion (Misc queries) | |||
Pass workbook name to ActiveX DLL (VB6) | Excel Discussion (Misc queries) | |||
Pass word protecting multipul worksheets within a workbook | Excel Discussion (Misc queries) | |||
Help with closing down a workbook?? | Excel Worksheet Functions |