Thanks Jim! That will disable the drag and drop functionality totally. I
was hoping for a solution that would allow someone to drag and drop, but
leave a named range in its original spot; the named range is copied and
pasted from the original source to the new destination. I was hoping to find
a way to just take the value, but not the named range that is attached to the
cell. I guess there is not a way to do this. Is that right?

Thanks,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jim Cone" wrote:


Tools | Options | Edit (tab)... uncheck "Allow cell drag and drop"
--
Jim Cone
Portland, Oregon USA
(I didn't click anything)



"ryguy7272"

wrote in message
Typically, Excel users can easily click on a cell, then get the black cross
with four arrows, and then drag and drop to another cell, to change the value
of the destination cell, overwrite the contents of the cell, etc. Is there a
way to disable this behavior? I dont mind users changing values of cells,
but I am trying to figure out a way to prevent users from changing a named
range (I have many named cells in my workbook). Id love to be able to do
this for the active sheet, or for a sheet with a specific name, such as
€˜Sheet1. If this is possible, obviously, it has to be done with event code.
Id greatly appreciate any recommendations or suggestions.
Thanks,
Ryan---