Re: Help. How do I disable a UserForm's close (X) icon?
- From: "Howard Kaikow" <kaikow@xxxxxxxxxxxxx>
- Date: Thu, 24 Apr 2008 02:54:50 -0400
Private Sub UserForm_QueryClose(Cancel As Integer, UnloadMode As Integer)
'Prevent user from closing with the Close box in the title bar.
If UnloadMode = vbFormControlMenu Then
Cancel = 1
MsgBox "Please use the " & Mid$(btnExit.Caption, 1) & " button to
close the Form", _
vbInformation + vbOKOnly, "Close box cannot be used to close the
Form"
End If
End Sub
--
http://www.standards.com/; See Howard Kaikow's web site
.
- Follow-Ups:
- Re: Help. How do I disable a UserForm's close (X) icon?
- From: jrlopezp
- Re: Help. How do I disable a UserForm's close (X) icon?
- References:
- Help. How do I disable a UserForm's close (X) icon?
- From: jrlopezp
- Help. How do I disable a UserForm's close (X) icon?
- Prev by Date: Help. How do I disable a UserForm's close (X) icon?
- Next by Date: Re: Programatically add a digital signature to a macro
- Previous by thread: Help. How do I disable a UserForm's close (X) icon?
- Next by thread: Re: Help. How do I disable a UserForm's close (X) icon?
- Index(es):
Loading