S
Soniya
Hi all,
what difference it makes having code under Auto_open or
under Workbook_open
TIA
Soniya
what difference it makes having code under Auto_open or
under Workbook_open
TIA
Soniya
J
John Wilson
Soniya,
Workbook_Open is an "event" that "fires" whenever a workbook
is opened.
Aut
pen 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 Autpen will only run when the workbook is opened manually.
John
Workbook_Open is an "event" that "fires" whenever a workbook
is opened.
Aut
pen is a "sub" that Excel recognizes and runs when a workbookis opened.
The main difference is that the Workbook_Open "event" fires whether
the workbook is opened manually or via code (from another workbook).
The Aut
pen will only run when the workbook is opened manually.John
K
keepitcool
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 >
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 >