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
HIS


"Eric" wrote in message
ink.net...
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

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

"Nick Hodge" wrote in message
...
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
HIS


"Eric" wrote in message
ink.net...
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

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
HIS


"Eric" wrote in message
ink.net...
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

"Nick Hodge" wrote in message
...
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
HIS


"Eric" wrote in message
ink.net...
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