just a quick one

C

chris

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
 
D

Dave Peterson

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.
 
Top