Data validation???

[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

 

[Ron de Bruin]

For a other solution you need VBA Gareth

 

[Gareth]

any suggestions?

For a other solution you need VBA Gareth

 

[Ron de Bruin]

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

 

[Jim]

Data>Validation>Settings tab>Allow>Custom> =A1="">OK.