Automated formula coping

[Guest]

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]

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