Coloring the row and column numbering bars in Exce2003
Try this in a sheet module.
Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim x1None As Boolean
Cells.Interior.ColorIndex = x1None
With ActiveCell
.EntireRow.Interior.ColorIndex = 35
.EntireColumn.Interior.ColorIndex = 35
End With
End Sub
If you have other cells colored within the sheet, it blows them away. Seems
there is a way around that but I do not have that solution at hand.
HTH
Regards,
Howard
"arasan77" wrote in message
...
I have a fairly large Excel work sheet and I need to traverse back and
forth
as well as up and down frequently. So I need to keep track of the row and
/
or column which I am traversing, lest I return to some wrong row or
column.
It would be, therefore, very helpful if there is an highlighting on the
row
and column numbering bars with a bright color, to help me note down before
traversing and return to the correct row / column, should I stray out. Is
there a method in Excel (Excel 2003) for achieving this?
Also presently I seem to have some such coloring scheme, but the color is
very close to the background colors of these bars, and I miss them many
times. Is there a way to change such a highlighting color as per my
choice,
to get a good contrast and get my attenetion readily?
Thanks for all who would provide me suitable answers.
|