Hi,

I guess you would have to select everycell on the sheet by clicking the
top left corner then right click in the highlighted area, then select
FORMAT CELLS, and then choose PROTECTION, click the LOCKED button until
it shows empty i.e no tick or shading, then select the row you want to
protect then right click in the highlighted area, then select FORMAT
CELLS, and then choose PROTECTION, click the LOCKED button a tick
should appear. The next time you protect the sheet (as locking cells
doesn't work if the sheet is unprotected) just that row will be
locked!

Hope this helps,

Regards,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=498669