Remove a cell's CF by double clicking it

J

Jock

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

Khuli

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

Jacob Skaria

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
 
Top