Maybe you could provide a macro that would unprotect the worksheet, do the
insert (and copy over formulas), then reprotect the worksheet.
David McRitchie has some code to insert rows and copy formulas at:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
TheRook wrote:
I have set up premission for editing data in a spreadsheet. It only allows
certain people to edit certain ranges. It also includes locked cells with
formulas in.
The permissions allow people to insert rows, and what I am wanting it to do
is automatically copy the formulas to the inserted rows.
Is this possible?
Regards
--
Dave Peterson