Some more follow up on this, as I still don't seem to be getting my
question answered. (I am sure its my fault for not explaining
properly).

For example I got one response from Jake Marx suggestion to look at
Chip Pearson's tutorial.

This I had already done, and have even used the APPEVENT.xls file. But
from what I can tell, the triggers on the APPEVENT.xls file, will do
exactly what I want, except for one small problem... They only work,
when APPEVENT is open. I want this to fire whenever I open any file,
without having to pre modify each file, and without having to open
APPEVENT. How do I get this functionality at a application level not a
file level.