Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Workbook_Activate() vs Workbook_Open()
7 views
Skip to first unread message
Robert Crandal
Nov 20, 2009, 7:41:23 PM11/20/09
to
So, when a user opens my Excel file, my Visual Basic script
is going to automatically fill the cells on the current sheet with
predetermined values....
is going to automatically fill the cells on the current sheet with
predetermined values....
My question is, does it make a difference if I place my
auto fill code into the Workbook_Activate() function
as opposed to the Workbook_Open() function??
I know that Workbook_Open() gets called before
Workbook_Activate()....so does it really matter WHERE
I place my initilization/auto fill code??
Thank you
JLGWhiz
Nov 20, 2009, 7:51:44 PM11/20/09
to
If you put it in the WB Open event, it only runs that one time to autofill
the cells. But if yoiu use the Activate event, it will run every time you
return to that workbook from another file triggering the activate event.
Other than that it probably doesn't matter too much.
the cells. But if yoiu use the Activate event, it will run every time you
return to that workbook from another file triggering the activate event.
Other than that it probably doesn't matter too much.
"Robert Crandal" <nob...@gmail.com> wrote in message
news:UGGNm.4602$kY2....@newsfe01.iad...
0 new messages