View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default just a quick one

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