Validation is pretty much just like formatting. So unless you want to
protect the sheet with the cell locked.

A code solution (although code can be easily disabled)

Private Sub Worksheet_SelectionChange( _
ByVal Target As Range)
Application.CutCopyMode = False
End Sub

use the selection change event for that sheet.

http://www.cpearson.com/excel/events.htm for an overview of events (Chip
Pearson's site)

--
Regards,
Tom Ogilvy


"Perico" wrote in message
...
Excel 2003: Does cell validation only work if the user types in the data,
as
opposed to pasting in the data? Put differently, is there a way to use
cell
validation so that if a user pastes values into the cell range, the
validation is not overwritten, not expunged?