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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting 1
Excel Named Ranges and Conditional Format 3
CF (If Formula Is ) placed into macro 1
Problem disabling double click event 1
fear of a bug, hope for a workaround 3
Formula for CF 1
A Huge Conditional Format Challenge.... 2
Formula for Dates and CF Colour then convert to Text 3

Back
Top