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)


wrote in message
ups.com...
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.