| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double Clicking File | Excel Discussion (Misc queries) | |||
| Double clicking a Cell Programatically | Excel Programming | |||
| Double Clicking | New Users to Excel | |||
| double-clicking a list entry | Excel Discussion (Misc queries) | |||
| Double-clicking entry | Excel Programming | |||
Hybrid Mode
