Hello all,

I have an Excel file that the users input the information. The sheet in the
file contains 10 columns (A-J), and the columns B,C,D and G are protected and
formula-driven. The way I have setup is the users can insert a new row
between two rows. The problem I am having is since some of the columns are
protected, the formula in those cells are not copied to the protected new
cells on the new row.

Is there a code that does the copying of the formula from the above
protected cell? Other suggestions are welcomed.

Thanks.