View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Listen for a close workbook

There is no wait capability in a macro that supports this.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I should have been more specific. 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 values.

Any ideas?