Im not sure, but here to put you on a good track.
In you VBA editor, add a reference to "Microsoft Visual Basic for Application Extensibility 5.3".
There you will find objects that manage the VBA interface. Mabbe in one of these objects, there would be an event to catch the loading of a VBA app?...
Hope this helps.
