MsgBox and VbYesNo not working for Exit Sub argument

The "Yes" and "No" Button MsgBox are both calling my given Sub "Overpaid_L_Grant" which means the Exit Sub is not working for "No". How can I click on the "No" button to exit Sub and "Yes" to just Call the Sub if the Sheets already exists?

Thanks

Sub Overpaid_LGrant_Exist()



Dim ws As Worksheet

Dim answer As Integer

On Error Resume Next

Set ws = Worksheets("Overpaid_LGrant")

On Error GoTo 0

If Not ws Is Nothing Then

MsgBox "Overpaid_LGrant Already Exists, Do you want to process it again?", vbYesNo + vbInformation

If answer = vbYes Then Call Overpaid_L_grant

If answer = vbNo Then Exit Sub

End If



End Sub

gijsmo, I changed the code with your code above but the problem is the same.... Attached is the example when you run "Overpaid L_Grant Exists" vba for your view

Appreciates your reply