I think you can prevent pasting by locking the cell and protecting the
sheet, but I don't believe you can validate a pasted value unless you use
VBA code to react to the action.
--
Regards,
Tom Ogilvy
"JR_06062005" wrote in message
...
The cell validation feature works fine when a user types a value into a
cell,
but does not prevent pasting in a value that does not meet the validation
criteria. Is there a way to validate values that are pasted into a cell?
|