Add row in a protected sheet filled with formulas from row above

[muhleebbin]

Could someone help with the code to add a row into a protected sheet but where it fills the row with the formula (if there is one) from the above row?

Basically i'd like to pick an unlocked cell within the sheet and have the macro insert a new row below that one and fill. If it could also highlight the current and new row, that would be awesome!

Also the code to undo this action would be helpful, I know there will be instances where this will accidentally be used.

Thanks in advance for your assistance.

 

[muhleebbin]

I have the following code but I'd like it to paste the values from above rather than the formula's that are in place, could someone assist in fixing this?

Worksheets("BofA Modified").Unprotect
   
    ActiveCell.Offset(1).EntireRow.Insert   
    ActiveCell.EntireRow.Copy ActiveCell.Offset(1).EntireRow
   
Worksheets("BofA Modified").Protect ""

 

[muhleebbin]

I did figure out the code to paste the values in the row below however I just realized I only want columns A-E to fill values whereas the rest of the row fills the formulas from the copied row. Could someone assist me in fixing this code to do that?

Worksheets("BofA Modified").Unprotect
   
    ActiveCell.Offset(1).EntireRow.Insert   
    ActiveCell.EntireRow.Copy
    ActiveCell.Offset(1).EntireRow.PasteSpecial xlPasteValues
   
Worksheets("BofA Modified").Protect ""