Force Manual Entry / Prevent Pasting

**FallingDown** · 01-25-2012, 05:03 AM

Hi all

I would need know whether I can for a manual entry into a cell. (i.e. prevent users from pasting values into it).
The thing is that they usually copy an entire line (let's sa columns A:BI) - but they ususally forget to update one particular field (column E)
so, what i need is, that if they paste the values to the new row all fields (A to D and F to BI) are filled in, but column E remains empty and requires a manual data entry?

Can this be done?

Thx a lot

**john55** · 01-25-2012, 05:31 AM

maybe this?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If MsgBox("Did you update ...Column E?", vbYesNo + vbQuestion, "Warning!") = vbYes Then
'your code here


Else
 ' Do nothing
     
End If
End Sub

**FallingDown** · 01-25-2012, 05:36 AM

Hi John

This only works if you paste the value directly, but not if it's included in a range

I'd prefer the option that if a range is pasted it simply skips the cell of column e.
(I have other checks in place to ensure that all mandatory fields of the file are completed - so your message box is not helpful for me)

But thank you for your efforts anyway

**Fotis1991** · 01-25-2012, 05:38 AM

Hi

If i understand well your point, then..

You can also do it, using Custom Validation, to force the users to fill first column E, or else they can not fiil enywhere else.

Note: This is not working for copy-paste.

**FallingDown** · 01-25-2012, 10:49 AM

Fotis

As pointed out, I do not want people to able to past values into the cell.
All other cells yes, but it should always require a manual entry for the cell in column E

Let's say they copy row 11 to row 12
--> then i want all values copies, apart from the value in column e