excel
 

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

excel
 

See Chip Pearson's section on this:

http://www.cpearson.com/excel/excelM...ightActiveCell


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

--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
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

excel
 

1. Please use meaningful subject lines.
2. right click sheet tabview codecopy paste thisif 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

--
Don Guillett
SalesAid Software

"Chris" wrote in message
...
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