Stop pasting

Salza · Oct 12, 2003

Hi all,

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

Regards,
Salza

Nick Hodge · Oct 12, 2003

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 · Oct 13, 2003

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

Deb

Peo Sjoblom · Oct 13, 2003

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

J.E. McGimpsey · Oct 13, 2003

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

Debra Dalgleish · Oct 13, 2003

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

Stop pasting

Salza

Nick Hodge

Deborah Bogan

Peo Sjoblom

J.E. McGimpsey

Debra Dalgleish