To be honest I havent created many Excel addins (.xla) but VB Add-Ins have an OnConnection and OnStartupComplete. You could also create the Workbook_New or Workbook_Open events.