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

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

On Oct 15, 2:14*pm, "Harald Staff" wrote:
I believe what you look for is hehttp://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- Hide quoted text -

- Show quoted text -

thank you that was very helpful