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
Code
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
Display More