[Whydidjuly]

Hi,

I have data validation that does not permit text to be written in the cell (Basically Text Length = 0). The range of cells with this validation was renamed "ValidationRange". A macro was created so you cannot paste over the data validation and erase it (http://www.j-walk.com/ss/excel/tips/tip98.htm).

However, it does not work if someone Pastes Special Values. Can someone help me with a VBA code to make this work?

[Claus Busch]

Hi,

Am Fri, 19 Sep 2014 18:40:29 +0100 schrieb Whydidjuly:

I have data validation that does not permit text to be written in the
cell (Basically Text Length = 0). The range of cells with this
validation was renamed "ValidationRange". A macro was created so you
cannot paste over the data validation and erase it
(http://www.j-walk.com/ss/excel/tips/tip98.htm).

However, it does not work if someone Pastes Special Values. Can someone
help me with a VBA code to make this work?

you don't need DataValidation.
Try following code. With this code you cannot select a cell into the
range:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Target, Range("ValidationRange")) Is Nothing Then
Target.Offset(, 1).Select
End If
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

[[email protected]]

Hi I'm interested if you have been able to validate phone numbers using excel. I'm just starting out and would love some ideas or better some working examples. Thanks in advance.