Macro that waits, then resumes after window is closed

[michael_mcclellan]

Does anyone know how to do the following:

I have a macro that does some things
including open up a workbook, then I need the macro to wait until this
workbook is closed while I edit some values, then proceed with the rest
of the macro.


Any ideas?

Thank you all in advance.

 

[Bob Phillips]

You will need 2 macros, one that opens the workbook and stops, and then trap
the BeforeClose event of that workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

ignore please
--ron