You could enable or disable DragAndDrop on a particular sheet
by using the Sheet_Activate/Sheet_Deactivate events.
It is very difficult to prevent copying and pasting.
You may need to place all of your data on a separate sheet and
protect it or hide the sheet.

Also, it is not clear if you are doing the copying and pasting or a user is.
You can, course, just copy data from a named range and paste values.
--
Jim Cone
Portland, Oregon USA



"ryguy7272"

wrote in message
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---