Formulas on double click

[peter]

Hi

If I double click on a cell that contains a formula the formula
appears instead of the result.

How do I deactivate this functionality?

 

[GS]

(e-mail address removed) explained on 10/8/2011 :

Hi

If I double click on a cell that contains a formula the formula
appears instead of the result.

How do I deactivate this functionality?

You can't, at least not easily. You'd have to trap the DoubleClick
event to do this. The DoubleClick event triggers EditMode and so Excel
thinks you want to edit the cell's contents (the formula), which is not
what is displayed (the result)!

What do you want to happen when you double click cells that contain
formulas?

 

[isabelle]

hi,

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


--
isabelle



Le 2011-10-08 09:50, (e-mail address removed) a écrit :

 

[peter]

hi,

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

Merci Isabelle
excel-vba.com

 

[isabelle]

de rien Peter, c'est avec plaisir