Formulas on double click

  • Thread starter Thread starter peter
  • Start date Start date
P

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?
 
(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?
Click to expand...

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?
 
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 :
 
Back
Top