Remove a cell's CF by double clicking it

  • Thread starter Thread starter Jock
  • Start date Start date
J

Jock

Is it possible to remove CF (there's only 1 condition) from a cell using the
Before Doubleclick() event?
Thanks,
 
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Target.FormatConditions.Delete
End Sub
 
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
 
Back
Top