Problems with Copy/Paste Code

I'm using code that SHG provided for me here; http://www.excelforum.com/showthread.php?t=630464

It worked great in the first workbook I set up but I just set up a new workbook and it's not doing the same thing. For example, it allows me to copy items from column A which have 1 type of validation (restriction on text) to another column which has a formula validation.

It still won't allow me to paste from outside a validated range to inside but I need to prevent people from screwing up the validation between columns. Any ideas?

ChemistB

Hello, Chemist,

I got your note. The prior code verifies that the validation range is the same, but not that the validation itself is unchanged. That would require (I think) storing all the validation information in a static array at initialization, and then checking the validation following any change in the spreadsheet.

I'm swamped this week, and won't have a chance to look at it until this weekend. Perhaps someone will jump in between now and then.

Regards,

Chemist, I hate to punt on you, but doing what I suggested seems like a pain in the neck -- or perhaps lower down ...

Why not instead disable cut and paste (intercept Ctrl+v and purge the clipboard) and drag and drop (save state, disable, and resore on exit).

Or maybe someone else will jump in with an easier solution ...

I'm fine with disabling the pasting and drag and drop functions if I just knew the code to write.

ChemistB

Hi all,
Still looking for resolution here. I have a workbook with conditional formatting and data val in unprotected cells (for manual entry) and unexperienced Excel users. I've put in the instructions to use Paste Special Values but I know someone will accidently put data into the wrong column and cut and paste them to the other column thus screwing up the D.V and C.F.

I'm not picky on how to do this; code that catches the person and doesn't allow paste or code that restores the original formatting (e.g. from a hidden sheet 2). Any thoughts? Thanks

ChemistB

I still need help with this. I tried manually defining the validationrange name using commas to separate different types of vals but then it wouldn't even let me input a value. :-/

Thanks in advance.

ChemistB