Disabling drag and drop - paste problems

D

Dave-R-W

I have disabled drag and drop in a spreadsheet as shown below, but this also
prevents pasting data into the workbook that has been copied from another
workbook - how can I overcome this? (Data copied from another application -
eg Word - can be pasted fine, except it sets the 'locked' property for the
cell, even though the worksheet is protected)

We are using Excel 2000, but the problem also exists in Excel 2003

Any help gratefully received!

Private Sub Workbook_Activate()
Application.CellDragAndDrop = False
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drag and drop 2
Disable Cut/Copy/Paste in Excel 2010 0
Drop and Drag Cell Data 1
Disable "Cut&Paste" and "Drag&Drop" 3
Paste special function in macros fail if we disable application cellDrap Drop 2
Drag and Drop 0
Drag and Drop 0
Disable "Cut" and "Drag & Drop" but not copy 0

Top