Drag and Drop

Hi Guy's, I'm wondering if anyone can help me here.

How can I stop drag and drop across a row but you can drag and drop down a column. Is this possible? If so, how?

Any help would be much appreciated.

Thank You
Jonah

Jonah, if you click the fill handle, that is the little black square in the lower right corner of a cell, and drag either down or across, it will fill (and fill in a series if it recognises it)

What behaviour do you want?

Educate the users, maybe?

You can't have a car that steers only left, to avoid colliding with the oncoming traffic on the right.
(that is for UK, OZ, ZA, JP and NZ and all the other places that drive on the wrong side of the road. Sorry. Still feels wrong after all these years)

(European/US version: )
You can't have a car that steers only right, to avoid colliding with the oncoming traffic on the left.

This workbook prevents copying & pasting,and most importantly, restores it.

Neat, Roy! but I can still select the source cell and adjacent cells below or right and use Ctrl-D to copy down and Ctrl-R to copy right.
Can that also be disabled?

Originally Posted by teylyn

Neat, Roy! but I can still select the source cell and adjacent cells below or right and use Ctrl-D to copy down and Ctrl-R to copy right.
Can that also be disabled?

Drag across to right doesn't work for me.

Just amended the code & this seems to even stop Teylyn

Please Login or Register  to view this content.

That's correct. Dragging is not possible in either direction. But I can select the source cell and the adjacent cells to the right and Ctrl-R to copy right.

this seems to even stop Teylyn

LOL, I'll try this in the morning! Too late for experiments now!

edit: tried just now. Can still select source and down and use Ctrl-D and can still select source and right and use Ctrl-R

I'm glad I'm just the tester and not the coder!

Originally Posted by teylyn

LOL, I'll try this in the morning! Too late for experiments now!

edit: tried just now. Can still select source and down and use Ctrl-D and can still select source and right and use Ctrl-R

I'm glad I'm just the tester and not the coder!

Did you run the amended code before testing?

This stops Ctrl-R as well

Please Login or Register  to view this content.

Originally Posted by Jonah

Hi Roy, here is my code, so that copy and paste is disabled but drag and drop isn't. What I'm asking for is for the ability to disable drag and and drop across rows. However, I do want drag and drop to be enabled up and down the same column.

Idon't think you can stop part of drag & drop

Did you run the amended code before testing?

duh - it was too late last night. I ran it now and it's working. Just for the record and the benefit of others reading this: switching to other workbooks in 2007 or 2010 that do not have the copy restrictions, will turn everything back to normal, so it might be a good idea to put the code in a worksheet change event or some such.

Hello Jonah,

The cell drag and drop function does not expose any VBA events which would be necessary to to control the direction. You can either have it enabled or disabled.