I've developed a protected sheet in excel 2003. I have protection set to
allow inserting rows. Unfortunately, the inserted row doesn't have formulas
of columns from previous row. Any way to do this?

Because what happens is users simply unprotect the sheet, and then copy and
insert rows in order to keep formulas intact in the inserted row. Of course
I don't want them unprotecting the sheet because then they can reek havoc.

Advice? Many thanks