Pendelfin

You are on the right track! Check to see if the cell is protected, Goto
Format cell Protect Check to protect. Next when you place your Data
Validation make sure there is a check mark in "Error Alert" tab "Show error
alert after invalid data is entered". Now protect the sheet via tools
protect.
I am using xl2k and this worked for me.

Does this help you?

Mike Rogers

"Pendelfin" wrote:

Is there a way to protect a cell so if there is a validation rule, where only
a value from a list can be entered, you are unable to paste invalid data into
this cell.

I have tried protectin the workshhet, workbook etc, but it still allows me
to copy external data and paste into the column with the validation rule
regardless of whether or not it falls in the validation list.

Many thanks for your help in advance.