Yong,

As Chip says, there is no such event, but if Excel is in automatic mode any
change to or creation of a name, either from the Excel user interface or via
VBA, will trigger a calculation event.

So maybe you could do something in the calculation event to check if the
contents of the names collection has changed.

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Chip Pearson" wrote in message
...
Yong,

There is no such event.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Yong" wrote in message
...
Hi

I want to be able to capture the change of defined excel name
which is created using workbook.names.Add(...).
Is there an event in Excel object model to do this?

Thanks

Yong