Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
End Sub

My understanding is that the "Cancel = True" should prevent the default
Excel behaviour ie if Edit Directly In Cell is on it should prevent it from
occurring.

For me it does not work - it still goes into Edit mode in the cell.
With Edit Directly In Cell off it goes to a precedent cell which is what I'm
trying to stop it from doing.

Any ideas?