If you unlock the cells in that column, then protect the worksheet, your users
can drag down--and also change everything else in that column.

You may want to use a macro that unprotects the sheet, inserts the row, copies
formulas, and reprotects the worksheet.

If you want to try that, take a look at David McRitchie's macro:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

Nat1 wrote:

If I have a worksheet that is protected and I have allowed a user to insert
rows, is there any way to also allow the user to drag down the formula from
the above cell?

--

Dave Peterson