Might be easier to download Chip Pearson's Rowliner add-in and install in
Office\Libraryand load through ToolsAdd-ins.

Now you will have the function for all workbooks.

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


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 13:26:01 -0800, carrera
wrote:

Wow...pasting that code was really great.
How would you make that into a macro to run whenever you want?

"CLR" wrote:

ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that does this nicely.....

Vaya con Dios,
Chuck, CABGx3



"suesolotel" wrote:

hi when i am checking data entry in a spreadsheet with a lot of information i
am having trouble keeping my on the row i am reading - is there a way you can
set the rows to shade in grey or similar so as you arrow down your eye is
always drawn to the current row you are reading?