You may be able to mess around with an event macro, but those will usually
destroy the undo stack, too.



James wrote:

Not quite what I was looking for but I have seen this add in, it is very cool
but it does make the undo option unavailable.

The shift + spacebar I already knew, but I was looking for a shortcut to
change the color of the cell and row (i.e. yellow or green). I just don't
like to use the mouse to much.

Thanks,
James

"Dave Peterson" wrote:

Shift spacebar will select the rows in the area with the activecell.

You may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

James wrote:

is there a keyborad shortcut to highlight the active row you are on?

Thanks

--

Dave Peterson


--

Dave Peterson