Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open Workbook_Open
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open Workbook_Open
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) 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open Workbook_Open
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) 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto_Open/Workbook_Open subroutines showing SCREENUPDATING | Excel Programming | |||
Cannot get Auto_Open or Private Sub Workbook_Open() to run at star | Excel Programming | |||
Auto_Open and Workbook_Open | Excel Programming | |||
Auto_Open and Workbook_Open in Addins | Excel Programming | |||
Auto_Open Vs Workbook_open | Excel Programming |