Sometimes in your Excel front-ends for TM1 you may want to capture events at an Application level
e.g. For every excel workbook open, you may want to capture the double click event and run a certain set of code.
The best way to do this I have found is using the following link:
http://www.cpearson.com/excel/AppEvent.htm