Have a macro that reformats a newly opened workbook. (Items such as deleting columns, and inserting formulas in a couple of fields.)
Would like to have the aformentioned macro (which is located in another workbook), add this event handler private sub below in addition to reformatting the page as described. It adds a highlight row.
The code I'd like to add is this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.FormatConditions.Delete
With Target.EntireRow
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
With .FormatConditions(1)
With .Borders(xlTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 2
End With
With .Borders(xlBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 8
End With
End With
.FormatConditions(1).Interior.ColorIndex = 42
End With
End Sub
Thanks in advance for some direction on this.
Petee
Bookmarks