Remove a cell's CF by double clicking it
 

Is it possible to remove CF (there's only 1 condition) from a cell using the
Before Doubleclick() event?
Thanks,
--
Traa Dy Liooar

Jock

Remove a cell's CF by double clicking it
 

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Target.FormatConditions.Delete
End Sub

Remove a cell's CF by double clicking it
 

Try the below

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

If this post helps click Yes
---------------
Jacob Skaria


"Jock" wrote:

Is it possible to remove CF (there's only 1 condition) from a cell using the
Before Doubleclick() event?
Thanks,
--
Traa Dy Liooar

Jock