Wait time between Saving and other activity

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

I have code that closes and saves a large workbook. I then display a message
box, but I can't seem to do anything with it for a while. I'm thinking it's
because the large workbook isn't really completely closed yet. Is there
some code that I can use to check that it's closed?
 
Just a thought, couldn't you add some code right before the msgbox
routine that counts the number of visible windows, or checks if the
file is still open, before displaying?

--JP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

closing another file by code causes failure to run workbook activate event 2
Save BeforeClose 1
Stop Auto Calculation Q 11
VBA editor doesn't prompt to save changes, doesn't save 3
Excel Providing user message when RED X clicked & properly closing application. 2
Opening a list of Excel files and run a macro in each 17
All Workbook Saved except This Workbook - Part2 3
Check for other open wokbooks 7

Back
Top