I have a macro in Sheet1 that will highlight selected row when you click on a cell.
What i would like to do is use a activex toggle button to either enable this when pressed or disable it when it is not pressed.
I cannot seem to get it laid out where it will work.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.FormatConditions.Delete
With Target
With .EntireRow
.FormatConditions.Add Type:=xlExpression, Formula1:=True
With .FormatConditions(1)
.Interior.ColorIndex = 20
End With
End With
End With
End Sub
Thanks, Gary
Bookmarks