Stop pasting

[Salza]

Hi all,

How to stop users from pasting a text/number into an unprotected cell?
Please help. Thanks.

Regards,
Salza

 

[Nick Hodge]

Salza

You could set up a Worksheet_SelectionChange() event. The code below will
stop a user pasting in cell C5 of the worksheet behind which the code
resides

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("C5")) Is Nothing Then
Application.CutCopyMode = False
End If
End Sub

 

[Deborah Bogan]

Depending on what your critria is you may be able to use
validation on the DATA menu

Deb

 

[Peo Sjoblom]

No, that is one thing validation won't do..

 

[J.E. McGimpsey]

Don't think so... Pasting into a cell overwrites the validation.

 

[Debra Dalgleish]

Data Validation does not stop users from pasting invalid data into a cell.