Selective Row delete protection

Is it possible to protect a worksheet and allow only certain rows to be deleted? From what I've seen, I don't think so, but I may have missed something.

See the image for the scenarioCapture.PNG
Only rows where Mandatory = No can be deleted.
I control adding rows with a macro (the + button in column A)
Data can only be entered in columns D, E & F.

The work around is to unprotect and re-protect your sheet within the macro. For some reason I'm unable to view the image you attached so I can't see which column the "Mandatory = No" data is stored. You'll have to adjust the code accordingly.

Sub DeleteSpecifiedRow()

On Error GoTo ErrorHandler:

Dim lRow As Long
Dim str As String

str = "password"   'Change this to your actual password within the quotations
lRow = InputBox("Which row number would you like to delete?")

If Not Range("C" & lRow).Value = "No" Then 'Change C to the column with Mandatory = No data
    MsgBox ("Only rows where Mandatory = No can be deleted")
    Exit Sub
Else
    ActiveSheet.Unprotect str
    Range("C" & lRow).EntireRow.Delete  'Change C to the column with Mandatory = No data
    ActiveSheet.Protect str
End If

Exit Sub

ErrorHandler:
ActiveSheet.Protect str
MsgBox (Err.Number & vbNewLine & Err.Description)

End Sub

Budget.jpg
I've reattached the image.
This is a budget template.
I do not want to necessarily delete rows, but want to allow the user to delete rows if they wish.
They can only delete a row if Mandatory = No.
If they add a row, using the + button in column A, a macro unprotects the sheet, inserts a row and copies the values in the row where the button was clicked for cells B and C.

I didn't want to go through asking which row to delete. I was hoping they could do it just via keystrokes.
I may have them indicate which rows if it has to be done by executing another macro
Thanks,