Auto_Open Vs Workbook_open
 

Hi all,

what difference it makes having code under Auto_open or
under Workbook_open

TIA

Soniya

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

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