Hi, haripopuri,

Any other events will not run the macro automatically upon workbook open or close.
Putting the Auto macros in a standard module will run them on opening or closing - even Excel2010 is supporting the old form of pre97 macros.

Ciao,
Holger