Another option, get hold of Jan Karel Pieterse's NameManager, it provides
*similar) functionality, although not under your control

It is a free add-in, and you can get it at
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"travis" wrote in message
ups.com...
I have an application where I'd like to execute code every time a cell
is named via the name box.

When the cell is named, I want a popup dialog asking if I would like to
add the named cell to the list of cells to be imported/exported by a
sub which pulls data from an older version of the spreadsheet into a
newer one.

If the user says "yes", I want the name of the newly named cell to be
added to this list, which resides in a sheet within the spreadsheet.
If not, don't add it to the list.

So I'm trying to figure out if there is an event triggered by changing
a cell or range's name?

Travis