views:

20

answers:

0

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.