Form Corner Red X

[Mileshigh]

Is there a way to disable the windows red x on a form or better yet have a sub run when its clicked?

 

[Andrew Poulsom]

Look here:

http://support.microsoft.com/kb/829070

 

[VoG]

Try like this in the userform's code module

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
    Cancel = True
    MsgBox "Click on a button to close!"
End If
End Sub