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