User Form Suppress Close Control Object

Re: User Form Suppress Close Control Object

I don't believe that is possible with the user form that is built into Excel VBA. Perhaps there's a third party User Form you could find that incorporates that functionality? I wish I had a direction to point you in but I'm at a loss on this one. Time for Google!

Re: User Form Suppress Close Control Object

EDIT:
Well, This thread shows exactly what mikerickson just posted. I found it at the top of this page, and was just about to post it.
Thx, mike...
http://www.ozgrid.com/forum/showthread.php?t=31400

You can do the following in the Terminate event. It's kind of generic and can be broken with Ctrl+Brk. The only problem is, you may lose data in text boxes and other controls, but it may suit your needs.

Private Sub UserForm_Terminate()
    UserForm1.Show
End Sub

Re: User Form Suppress Close Control Object

Private Sub UserForm_QueryClose(Cancel As Integer, closemode As Integer)
If MsgBox("OK to close?", vbOKCancel) = vbCancel Then Cancel = True


End Sub

Re: User Form Suppress Close Control Object

See Stephen Bullen's FormFun example for code to remove actual button.