BeforeDoubleClick Cancel=True not working
 

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?

BeforeDoubleClick Cancel=True not working
 

Have since discovered the problem is due to the Applix TM1 Add-In interfering
with the Cancel Boolean.

"Reggie" wrote:

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?