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---



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