I have recently written up information on using a central event handler.
http://www.andypope.info/vba/ufevents.html