Is there any way to hook into the creation of a named range or list object in Excel 2007 using VSTO? I need to track the named ranges in a worksheet and, as such, need to be alerted when a new one is created.
I have tried the SheetChange and SheetCalculate events and neither is triggered on the creation of a new named range.