Even procedure in xla

[Michael]

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

 

[Harald Staff]

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

HTH. Best wishes Harald

 

[Michael]

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

HTH. Best wishes Harald








- Show quoted text -

thank you that was very helpful