Maybe you could use a macro.
It would unprotect the worksheet (is that required?), then copy|insert the
following row, remove formulas/constants???, but keep the formatting???), then
reprotect the worksheet.
If you want to try, you could record a macro when you do it manually. Then
tweak that macro.
David McRitchie has a version that you may want to review:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas
It uses the row above, but may give you some ideas.
chris wrote:
Ok guys..and gals...is it possible when inserting a row..to have it default
to format same as below..instead of allowing an option of below or above...my
above row is loocked..and when the user inserts a row..i want it
automatically formatted same as below...the unlocked row..so that they can
access this new row.
thanks
--
Dave Peterson