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