View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Workbook_Activate() vs Workbook_Open()

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