Neil.

You can elect for the user to be able to select locked cells, and to
Insert rows, this should help.



Neil_Pattison Wrote:
The problem I have with that is that I have protected the cells
containing the formula so that a user cannot mistakenly delete it, so
they won't be able to select the cell and then drag it down


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=472528