a "cell is renamed" event?
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
|