View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John D[_3_] John D[_3_] is offline
external usenet poster
 
Posts: 1
Default Can a named range be protected???

For example, If I had a worksheet used to collect 10
financial values, with the 10 cells named FinVal1 thru
FinVal10 respectively, locked all other cells on the
sheet, protected the sheet...

Now, as an example if a user Cuts the cell named FinVal1
and pastes it over the cell that is named FinVal6, then
FinVal6 will no longer exist.

Is here a way to prevent users from pasting cell obects
over others that are named? This silently creates havoc
elsewhere in the spreadsheet that may reference the
former named range.