Protect cells from being changed, and allowing users to delete rows.

Hi,

Hoping someone can help.

In my spreadsheet I’d like to protect column D from being changed, and columns G & M to have the formulas hidden.

I have a macro to create a dashboard, and a macro to highlight the row.

I need the end users to be able to delete rows so they only send the relevant data to managers.

Is there any way of doing this.

Thank you