Prevent drag copy

[sowetoddid]

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

 

[Earl Kiosterud]

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

 

[sowetoddid]

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

 

[Dave Peterson]

You have some more replies in .excel

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.