highlighting row

[Guest]

I have a very large spreadsheet with first and last names
in the first two columns. Is there any way for me tell
the spreadsheet to highlight the row I am on when I click
on a cell?

 

[Ken Wright]

This will do as you want, BUT, beware that this effectively disables any undo
levels - so be careful:-

http://www.cpearson.com/excel/rowliner.htm

 

[Ron de Bruin]

Check out this

This one from J.E
http://www.mcgimpsey.com/excel/highlightrow.html#HiLiteRetainColor

Or Chip Pearson's RowLiner add-in
http://cpearson.com/excel/RowLiner.htm

 

[Ken Wright]

And also see the caveat I gave in my note re undo levels.

 

[Ron de Bruin]

Hi Ken

my note re undo levels

Most macro's have that problem

But maybe a note about this on the sites is a suggestion for J.E and Chip

 

[Guest]

Wow! Thanks it works great. But, how do I make it work
when the spreadsheet is protected?? PS I am the person who
protected it, but I want it protected when others use it.