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