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