I tried Bob's code straight away and it worked super fine......

Here's a little variation to highlight the cell in a different way.....

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.ClearComments
With Target
.AddComment.Visible = True
.Comment.Text ("Edit Me")
End With
End Sub

Vaya con Dios,
Chuck, CABGx3



"flow23" wrote in message
...
I have huge database, which other colleagues view regularly.

and I wondered if there is a way to highlight the activerow to make it
easy
to read?