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