Preserving lock on cells even when copied and pasted within a sheet
 

Hi,

I am trying to create a worksheet that is flexible enough so that
additional rows can be created (by copying existing rows from above) if
additional data becomes available to be entered. Locking rows with
formulas and protecting the sheet does allow the user to copy and paste
the cells or rows (most often accomplished by dragging by the handle);
however, the lock is no longer preserved if the destination rows
unlocked to begin with. On the other hand, if the destination rows are
locked, then the user cannot drag (or copy/paste) into them. I had
assumed that copy and paste (or drag) would preserve cell formats,
including teh fact that they are locked, but I guess I was wrong.
Users will be working with either Office 2002 or Office 2003; the
worksheet template is being created in Office 2002.

Thanks for any help you can provide!