Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The below code works by highlighting a row based upon a selection from
a drop down box. But then I am no longer able to use my mouse to select another cell. Range("A5:L5") stay selected. I am thinking it should be a quick fix but I cannot figure it out. Thanks for any help you can lend to this matter. The code was courteous of Tom Ogilvy Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("N5") = 3 Then Range("A5:L5").Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With Else Range("A5:L5").Select Selection.Interior.ColorIndex = xlNone End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Running Macro when a cell value changes | Excel Discussion (Misc queries) | |||
Running a macro on cell value change | Excel Discussion (Misc queries) | |||
Running a macro on cell value change | Excel Discussion (Misc queries) | |||
Running a macro on cell value change | Excel Discussion (Misc queries) | |||
Running a macro in a selected cell... | Excel Discussion (Misc queries) |