Tick,
If I were to write a VBA version of the event monitor-macro launcher would you be interested in making it into an addin? I was thinking it would have an mdb database or something that it would read at startup. The mdb would be set up with a list of all the events that the addin recognizes, and the end user would just add their path to the desired macro corresponding to the event. The addin itself would just be a bunch of similar functions for every event. The individual event functions would call one main function, telling that one what event it was. The main function would check the database to see if a macro was associated with that event and, if so, run that macro. That way less-experienced VBA programmers would have the ability to trigger macros with events.
I suppose it could use too many resources to monitor a large number of events. And if the user links too many complex macros to many events there could be cascading effects, caused by one event triggering a macro, whose running fires other events, triggering other macros.
What do you think?