Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open Vs Workbook_open
Hi all,
what difference it makes having code under Auto_open or under Workbook_open TIA Soniya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open Vs Workbook_open
Soniya,
Workbook_Open is an "event" that "fires" whenever a workbook is opened. Auto_Open is a "sub" that Excel recognizes and runs when a workbook is opened. The main difference is that the Workbook_Open "event" fires whether the workbook is opened manually or via code (from another workbook). The Auto_Open will only run when the workbook is opened manually. John Soniya wrote: Hi all, what difference it makes having code under Auto_open or under Workbook_open TIA Soniya |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open Vs Workbook_open
Hi Soniya..
workbook_open runs first and auto_open next When you open a book manually: BOTH will run UNLESS you keep SHIFT key pressed. When you open a book with vba: the auto_open WILL NOT run UNLESS you add the line (after open) ActiveWorkbook.RunAutoMacros xlAutoOpen the workbook event code WILL run UNLESS you add (before open) Application.EnableEvents = FALSE I think Auto_open was left in for backward compatibility with excel4 macros. Personally I'd use Workbook_Open keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Soniya" wrote: Hi all, what difference it makes having code under Auto_open or under Workbook_open TIA Soniya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Private Sub Workbook_Open() doesn't run | Excel Discussion (Misc queries) | |||
Breaking into Workbook_Open | Excel Discussion (Misc queries) | |||
About workbook_Open madro | Excel Worksheet Functions | |||
Workbook_Open() Event | Excel Discussion (Misc queries) | |||
Workbook_Open () | Excel Discussion (Misc queries) |