highlight the current cell
Right click on the sheet tab, select view code, and put in code like this:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
End Sub
Note that this clears the clipboard and clears the undo stack as I recall,
so you will not be able to paste or undo.
--
Regards,
Tom Ogilvy
"D" wrote in message
...
I would like to be able to have the current cell highlighted in Excel.
This
would change based on my cursor position. I think I have seen this before
but
I cannot find it now. Thanks for the help.
|