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?

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?