If you want to instantiate application level events and have the open event
check each workbook opened to see it is the one - then run the code.

see Chip Pearson's site on application level events

http://www.cpearson.com/excel/AppEvent.htm

--
Regards,
Tom Ogilvy

"Ric" wrote in message
...
Hi,

Is there a way to have a macro automatically run every time an excel
workbook is opened, where the macro in question resides in the
personal.xls
or an add-in rather than being part of the document that is being loaded?

Thanks,
Ric