View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default 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