Auto_Open Workbook_Open

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


<yngve.angelskaar@fusi.no> wrote in message
news:1130882517.823893.197400@g43g2000cwa.googlegroups.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
>

Bob Phillips skrev:
> That is essentially the difference.
>
> Auto_Open is the original way of having a macro run at workbook startup, but
> with the introduction of events in XL97, the Workbook_Open event was
> introduced. Auto_Open is retained for compatibility.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> <yngve.angelskaar@fusi.no> wrote in message
> news:1130882517.823893.197400@g43g2000cwa.googlegroups.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
> >

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
>
>
> <yngve.angelskaar@fusi.no> wrote in message
> news:1130882517.823893.197400@g43g2000cwa.googlegroups.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
> >

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

That is essentially the difference.

Auto_Open is the original way of having a macro run at workbook startup, but
with the introduction of events in XL97, the Workbook_Open event was
introduced. Auto_Open is retained for compatibility.

--

HTH

RP
(remove nothere from the email address if mailing direct)


<yngve.angelskaar@fusi.no> wrote in message
news:1130882517.823893.197400@g43g2000cwa.googlegroups.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
>

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


<yngve.angelskaar@fusi.no> wrote in message
news:1130882517.823893.197400@g43g2000cwa.googlegroups.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
>

Bob Phillips skrev:
> That is essentially the difference.
>
> Auto_Open is the original way of having a macro run at workbook startup, but
> with the introduction of events in XL97, the Workbook_Open event was
> introduced. Auto_Open is retained for compatibility.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> <yngve.angelskaar@fusi.no> wrote in message
> news:1130882517.823893.197400@g43g2000cwa.googlegroups.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
> >

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
>
>
> <yngve.angelskaar@fusi.no> wrote in message
> news:1130882517.823893.197400@g43g2000cwa.googlegroups.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
> >