DISABLE CLOSE("X")BUTTON OFUSERFORM

To disable the close(X) button
of userform paste the below
code on the QueryClose event
of your userform.
Private Sub
UserForm_QueryClose(Cancel
As Integer, CloseMode As
Integer)
If CloseMode = 0 Then
Cancel = True
MsgBox "The X is disabled,
please use a button on the
form.", vbCritical
End If
End Sub