Hello,

You can protect the worksheet and still allow others to insert rows.
If you are in Outlook 2003:

1. Unlock and unprotect all cells (Ctrl-A, then Ctrl-1, Protection
tab, uncheck 'Locked' and 'Hidden')
2. Select the formula cells you want to protect, hit Ctrl-1,
Protection tab, check 'Locked' and 'Hidden')
3. When protecting your worksheet, under 'Allow all users of this
worksheet to", select 'Insert rows'

HTH,
JP

On Oct 5, 1:54 pm, susy wrote:
Hi my name is susy,

I'm working on a finacial structure that should be used for entry of data by
many person. I thought about locking the worksheet, but some else shoul be
able to insert a row a keep working withou messing with my formulas.

What should I do to automatically insert a row with the same formula at
least with the same formats?

susy