I believe what you look for is he
http://www.cpearson.com/Excel/AppEvent.aspx

HTH. Best wishes Harald

"Michael" wrote in message
...
Is there a way to define a sub in an even procedure that will be
recognized the the active book if the xla is loaded?
I want to above having to put the even proceedure in the workbook
module of every workbook. I want it to run with all the other code
stored in the xla.

Any help would be appreciated

Thank you