Different active cell

  • Thread starter Thread starter Raymond Andersen
  • Start date Start date
R

Raymond Andersen

Is it possible to let the active cell have a, for example,
different color or bold etc. Thus, when you move around in
the spreadsheet, you can easy see where you are, because
the cell you are in is different?
 
In ThisWorkbook Module enter:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
On Error Resume Next
Sh.Cells.Interior.ColorIndex = xlColorIndexNone
Target.Interior.ColorIndex = 6 ' yellow - change as needed
End Sub

HTH
 
Back
Top