Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Code works sometimes, but no firing at times.
Any clues? Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.EnableEvents = False If Not Application.Intersect(Target, Range("j1:j65000")) Is Nothing Then If Selection.Value < "DONE" Then Selection.Value = "DONE" Range("A" & Selection.Row & ":j" & Selection.Row).Interior.ColorIndex = 15 Else Selection.Value = "" Range("A" & Selection.Row & ":j" & Selection.Row).Interior.ColorIndex = xlNone End If End If Application.EnableEvents = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming | |||
Stop Worksheet_SelectionChange event from firing? | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming |