View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
evgny[_2_] evgny[_2_] is offline
external usenet poster
 
Posts: 28
Default Auto_Open Workbook_Open

Thang`s for replying and god explanation

Regards yngve

Chip Pearson skrev:
They are very similar. Auto_Open is older than the Workbook_Open
event (events were added in Excel 97). One major difference is
that if a workbook is opened via VBA (as opposed to the
File..Open menu item), Auto_Open will not run, while
Workbook_Open will.


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


wrote in message
oups.com...
What is the diferent between Auto_Open and Workbook_Open, when
I use
Auto_Open in a module and open the workbook with a macro the
Auto_Open
is not runing, workbook_Open runs.

Regards Yngve