excel

[Chris]

Thanks in advance. This is probably not a question which
is asked alot but i have a number of users opening very
large excel sheets. A few users suggested that it might
be easier to where they are in a sheet if when selected
the cell either highlighted with colored background or the
color of the selected cell's border changed to another
color. Is this possible and if so any help would be much
appreciated.

Thanks,
Chris

 

[Tom Ogilvy]

See Chip Pearson's section on this:

http://www.cpearson.com/excel/excelM.htm#HighlightActiveCell


Note that using this approach will probably eliminate the ability to use the
undo function in the worksheet.

 

[Don Guillett]

1. Please use meaningful subject lines.
2. right click sheet tab>view code>copy paste this>if you don't want the
whole row just take out the .entirerow part.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Target.EntireRow.Interior.ColorIndex = 36
End Sub