Like your previous post while protecting the worksheet check the Insert Rows
Checkbox and enter your protection password and give ok. So the users are
not required to unprotect the workbook for inserting rows.

Alt+T+P+PAllow All User of this Worksheet to:Check the Insert Rows check
box

About the filling of Formula to a newly added row should be done manually by
pressing Cntrl+D or you should go for macro solution.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Chris" wrote:

How can I allow users to insert row's with the formula added automaticly
without unprotecting sheet
regards
Chris