highlight cursor in Excel
Putting the following code in the worksheet's Selection Change event will
color the active cell dark red, with a white font. Setting the remaining
cells to standard background and foreground colors.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveSheet.Cells.Interior
.ColorIndex = xlNone
End With
ActiveSheet.Cells.Font.ColorIndex = vbBlack
With Selection.Interior
.ColorIndex = 9
.Pattern = xlSolid
End With
Selection.Font.ColorIndex = 2
End Sub
--
Kevin Backmann
"DrJeckyl" wrote:
In the old day in Excel you had th ability to hightlight the cursor. Doe
anybody know how we can do that? In today's Excel.
Thanks
|