Yes or no confimation before macro runs.

[Subtotalatom]

I have this formula (Kindly edited by Logit).

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 10 Then
If Target.Value = "Invoice Complete" Then
'Turn off events to prevent recursive calls
Application.EnableEvents = False
'Copy row to new worksheet
Target.EntireRow.Copy
With Worksheets("Complete")
.Range("A" & .Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteAll
End With
'Delete the source row
Target.EntireRow.Delete
'Turn events back on
Application.EnableEvents = True
End If
End If
End Sub

however i need the spreadsheet to prompt the user to confirm with a yes or no box before it runs. because if the user changes the cell by accident the macro will run said script meaning potential mistakes.

i have attached the spreadsheet to show what the spreadsheet will do - if you change the J column cells to Invoice complete it will run the script