Active Cell/Focus
Put the following macro in the worksheet code area:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set t = Target
Cells.Interior.ColorIndex = xlNone
t.Interior.ColorIndex = 6
End Sub
It will color the ActiveCell as yellow.
--
Gary''s Student - gsnu200774
"Rich W." wrote:
I was wondering if there is a buried setting in Excel that allows the cell
that has the current focus to standout.
A user would like to change a setting in Excel so that whatever cell has
focus stands out (I suggested using the name box and/or row/column
indicators, but that's not flying.)
Or, possibly, a macro . . . any one know of anything? Thanks in advance,
Rich
|