View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Workbook_Activate question

Pete,

Yes, the Activate event will run, after the Open event runs.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Peter Rooney" wrote in
message
...
Good afternoon, all!

If, via VBA, I open a workbook that contains a
workbook_activate macro, will
it run when the workbook opens (and by default activates), or
only if I
reference it call it specifically from within my calling macro?

Thanks in advance

Pete