OK, how about disabling the user's ability to click the X button on the userform?
Add this to the userform code module
Code:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then Cancel = True
End Sub