event to know after data has loaded

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I have a large workbook with close to 200 sheets in it, so it takes awhile
for it to open (10 seconds or so).

Is there a way for my vba code to know when the workbook is done opening, so
I could then start my code?

TIA
 
Eric

You could place it in the Workbook_Open() event. This way it should run as
soon as it can???

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Hi Nick,

That's what I have been doing, but doing so obscures all my nice status
messages and makes it more difficult to debug all the setup work ive got
going in there.

Thanks
 
Eric

What about forcing a calculation on a worksheet as a last line and then
doing something with the Worksheet_Calculate() event?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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

Is there a command to 'Hide' the Activeworkbook? 1
closing another file by code causes failure to run workbook activate event 2
how to reshow userform after following a link 1
How to append data from different sheet and different workbook? 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Read data from workbook without showing it? 7
Class versus Another Way, Wbk and Sheet Custom Data Needs 1
Handling a worksheet calculate event in XLA code 4

Back
Top