another tip for shared code...?

centralize individual eventhandlers by using the application object's
events, so you can monitor all workbooks in the running instance from 1
place..

see
http://www.excelforum.com/showthread...hreadid=275605
be sure to follow link to chip's site.


have fun!

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"SixSigmaGuy" wrote :

God, that was so easy. Thank you. I used the reference method.
Geezz, I just failed to consider the obvious. Too bad they didn't
mention that in the code sample I was going by.

This allows me to have a shared code project so I don't have to make
copies in every project that all end up getting out of sync over time.

Thanks a lot!!