Have you tried deselecting "Drag and Drop" in Tools - Options - Edit?

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"sowetoddid " wrote in message
...
Is it possible to deactivate the drag and copy function so that a user
cannot copy values and drag them to the next 3 rows over. I have
already deactivate drag and drop and that still leaves a hole for users
to manipulate the spreadsheet.


Thanks.


---
Message posted from http://www.ExcelForum.com/