excel defined name change event
 

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

excel defined name change event
 

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