Hi

I have a worksheet (Excel 2003) on which I need to disable drag and drop.
Doing so within the worksheet_activate area as shown below works fine, BUT
doing this also prevents the user copying in data from another open workbook.

How can I disable drag and drop, but allow pasting from another workbook?

Thanks
dave

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

Try to turn on drag and drop with wrokbook deactivate event.
H
"Dave-R-W" wrote in message
...
| Hi
|
| I have a worksheet (Excel 2003) on which I need to disable drag and drop.
| Doing so within the worksheet_activate area as shown below works fine, BUT
| doing this also prevents the user copying in data from another open
workbook.
|
| How can I disable drag and drop, but allow pasting from another workbook?
|
| Thanks
| dave
|
| Private Sub Workbook_Activate()
| Application.CellDragAndDrop = False
| End Sub
|

Hi

drag and drop is disabled using the deactivate event. A user can go to
another workbook and copy a cell, and paste it either in that workbook or
somewhere else, just not into the workbook I'm using. It's as if the
activate event clears the clipboard...

Data can be copied in from another office application - eg Word, but not
from another spreadsheet.

"Homey" wrote:

Try to turn on drag and drop with wrokbook deactivate event.
H
"Dave-R-W" wrote in message
...
| Hi
|
| I have a worksheet (Excel 2003) on which I need to disable drag and drop.
| Doing so within the worksheet_activate area as shown below works fine, BUT
| doing this also prevents the user copying in data from another open
workbook.
|
| How can I disable drag and drop, but allow pasting from another workbook?
|
| Thanks
| dave
|
| Private Sub Workbook_Activate()
| Application.CellDragAndDrop = False
| End Sub
|