Automatically copying fomulae when Inserting rows

[Guest]

I have a spreadsheet which has some complicated formulae in some cells, so I
want to lock and protect those cells to prevent other users from spoiling
them.

However, one of the things these users need to do is to insert rows to add
new data in the correct place. I would like the formulae from the
corresponding cells above the new row to be automatically copied. The only
way to get the formulae in that I know is to use the "fill handle" but you
cannot do that when the cell is locked.

Is there another way?

 

[Guest]

Hi Ian,

If you and your users are all using Excel 2002 or later, you can protect the
worksheet but still allow users to insert rows. Have a look at the options
when you select protect worksheet from the menu.

Hope this helps,

Mark

 

[Guest]

Hi Mark

Yes - I know you can allow them to insert rows, but how can you then copy
the formulae from the protected cells in the row above (or below) the new
row? I was hoping this could be done automatically.

Ian

 

[David]

=?Utf-8?B?SWFuIEdvb2RoYXJkdA==?= wrote

Hi Mark

Yes - I know you can allow them to insert rows, but how can you then
copy the formulae from the protected cells in the row above (or below)
the new row? I was hoping this could be done automatically.

Ian

Have a look here: (it ain't easy, but doable)

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