Look at Chip Pearson's discussion (summary - one is old, one is new)
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

wrote in message news:FYwQd.65995$2p.5631@lakeread08...
All -

I don't understand the differences between Auto_open and
Workbook_beforeOpen, or those for their closing brethern.

Why should one be preferred over the other? Why are there two thigns
that do the same intent?

...best, Hash