how to prevent user from closing User form

[acherony]

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

 

[Greg Maxey]

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

 

[Kodeworks]

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