Hello!

As the title states, I need to delete rows in sheet with protected cells.

I would like to do this by way of a button which I can press, at the end of each row.

I would like a warning box to come up when I press the button which asks "Do you really want to permanently delete this record?"

There should be a "Yes" and a "No" button on the warning box.

Pressing "Yes" will delete the cells in that row with information in (I don't want to delete the entire row as there are hidden cells with list text in them).

Pressing "No" will simply close the warning box.

I have never written a macro (which I believe is the way forward with this).

I have read that the macro will need to un-protect the sheet, perform the action, then protect the sheet again.

Any help is greatly appreciated.