David McRithchie has done it for you.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Scroll down to...................

Code for the InsertRowsAndFillFormulas Macro (#insrtrow)


Gord Dibben MS Excel MVP


On Tue, 22 Dec 2009 01:29:01 -0800, Chris
wrote:

How do I do a macro for this. I have NEVER done one before.
Thanks
Chris

"Ms-Exl-Learner" wrote:

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