Workbook_Activate() vs Workbook_Open()

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
 
J

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top