Knowing when Solver closes
I am launching solver via a command button which uses SendKeys to invoke the
dialog. I cannot control what the user does with solver and I don't want to.
What I do need, is some way to "know" the very instant that they close the
Solver dialog. The closest I can get is the Worksheet_SelectionChange, and
it is not good enough. Can someone recommend something I can do from API
perhaps? Some condition I can test on a timed basis maybe?
|