View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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