Excel - Workbook_Activate() vs Workbook_Open()

Asked By Robert Crandal

20-Nov-09 07:41 PM

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....

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

20-Nov-09 07:51 PM

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 does not matter too much.