Data validation???

  • Thread starter Thread starter Gareth
  • Start date Start date
G

Gareth

I want to stop users entering data into a cell without protecting the sheet.

I have tried setting data validation to Text length and the amount of
characters to 0. Is there a better way?

Thanks in advance.

Gareth
 
One way

Place this event in the sheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("B3"), Target) Is Nothing Then
Target.Offset(1, 0).Select
End If
End Sub

You can't select or edit B3 now
 
Back
Top