R
Robert Crandal
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
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