View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex J Alex J is offline
external usenet poster
 
Posts: 85
Default <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