Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent - Ctrl-V between sheets, not allow Drag and drop
Hi,
I really need to get this working, so please help me if you know a solution. I want to be able to do Crl-C and Ctrl-V with data between sheets, but I have a Application.CellDragAndDrop = False within my Worksheet_Activate Sub. It seems like the celldraganddrop clear the clipboard. Within the sheet, It is all ok. to make Ctrl-C / -V. But I have to paste between sheets and I have to not allow celldraganddrop. Is there a way to keep clipboard content in antother "mode" and pick it up when needed? Can I use another event to stop Draganddrop? What?? This is how the sub look now and if I take away CellDragAndDrop line, i can paste from another sheet as I need. But... Private Sub Worksheet_Activate() On Error Resume Next Application.CellDragAndDrop = False Application.ScreenUpdating = False Application.EnableEvents = False .... ... /Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drag & Drop | Excel Worksheet Functions | |||
Cannot increment numbers on Ctrl+ drag the cells. | Excel Discussion (Misc queries) | |||
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
drag and drop | Excel Discussion (Misc queries) | |||
Drag and Drop | Excel Programming |