MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disable "X" on userform..


Posted by Mann on January 18, 2002 7:49 AM

How can i diabled the "X " at a useform. So the user
have to use the button that I attached at the userform
to close the userform . Thanks


Posted by Jerid on January 18, 2002 7:55 AM

Place this in your forms code module.

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

If CloseMode = vbFormControlMenu Then
Cancel = True
End If
End Sub