Different active cell

[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?

 

[JMay]

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

 

[Andy B]

Raymond

Try Chip's RowLiner at:
http://www.cpearson.com/excel/rowLiner.htm

Andy.