<Pass the Torch from a Closing Workbook
"Alex J" wrote...
....
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).
....
If wbB should only open when wbA opens it, and control should return to wbA
when it's closed, why not have the button in the userform in wbB call a
macro in wbA that closes wbB and proceeds on to whatever else you want wbA
to do?
--
To top-post is human, to bottom-post and snip is sublime.
|