View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
travis[_3_] travis[_3_] is offline
external usenet poster
 
Posts: 58
Default 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