Can you disable button on a UserForm?

[j_Southern]

I have a userform that I want to be closed/hidden by using a button that ensures that files are copied as the form is hidden. My problem is that the form also has a close cross and i have not been able to find a way to disable this. Alternatively can I associate the code of the command button with hitting the cross?
Hope somebody can help
regards
John

[Kyle123]

This will disable the cross on the userform:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Cancel = 1
MsgBox "Please use the buttons on the Form to close this window", vbExclamation + vbDefaultButton1
End Sub

[Andy Pope]

There is API code to remove the button.
See FormFun example file.
http://www.oaltd.co.uk/Excel/Default.htm

or you could catch the event

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

    If CloseMode = 0 Then
        MsgBox "Please use Close Button Provided"
        Cancel = True
    End If
        
End Sub