Is it possible to deactivate the drag and copy function so that a use
cannot copy values and drag them to the next 3 rows over. I hav
already deactivate drag and drop and that still leaves a hole for user
to manipulate the spreadsheet.


Thanks

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

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/

I have already disabled the drag and drop function. I just thought o
the work for what I want to disable .... AutoFill

What Private Sub would deactivate the AutoFill fuction in a workbook.


Thanks

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

You have some more replies in .excel

"sowetoddid <" wrote:

I have already disabled the drag and drop function. I just thought of
the work for what I want to disable .... AutoFill

What Private Sub would deactivate the AutoFill fuction in a workbook.

Thanks.

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

--

Dave Peterson