ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent drag copy (https://www.excelbanter.com/excel-programming/302046-prevent-drag-copy.html)

sowetoddid[_51_]

Prevent drag copy
 
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


Earl Kiosterud[_3_]

Prevent drag copy
 
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/




sowetoddid[_52_]

Prevent drag copy
 
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


Dave Peterson[_3_]

Prevent drag copy
 
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



All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com