how to prevent user from closing User form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

acherony - 19 May 2006 15:50 GMT

HI!,

I made one template macro using Autonew()
Which start UserForm.

I need to prevent/block the User from closing the UserForm with close button
of
Windows from UserForm.

Need Disable Windows close button of Window.

need help

Reply to this Message

Greg Maxey - 19 May 2006 15:58 GMT

See:
http://word.mvps.org/FAQs/Userforms/DisableClose.htm

Reply to this Message

Kodeworks - 19 May 2006 23:34 GMT

acherony

Try using the QueryClose event of your userform. It fires before the
UserForm closes and you can detect what's trying to close your
userform.

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As
Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
End If
End Sub

Sunil Jadwani
Kodeworks - Business Automation Solutions
www.kodeworks.com

Reply to this Message

Rate this thread: