How to protect cell names?

[Brett]

When I do a ctrl-x in one cell & ctrl-v in another it moves the contents of
the
1st cell to the 2nd, which I want. However the cell name of the 1st cell
moves
to the 2nd cell, which I don't want. What do I change so the cell names stay
in their original location?

Thanks in advance for any help

 

[JE McGimpsey]

When I do a ctrl-x in one cell & ctrl-v in another it moves the contents of
the
1st cell to the 2nd, which I want. However the cell name of the 1st cell
moves
to the 2nd cell, which I don't want. What do I change so the cell names stay
in their original location?

One way:

Define the name using Insert/Name/Define

Name in workbook: <name>
Refers to: =INDIRECT("Sheet1!A1")

 

[Brett]

I think this works based on my tests. However, the name
appears hidden ... e.g. in the name box it says "A1", instead
of the cell name I selected. Is there a way so the name box
will show the name I selected?

thanks for you help

 

[JE McGimpsey]

AFAIK, no.