Thread
:
event to know after data has loaded
View Single Post
#
4
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
event to know after data has loaded
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
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge