How to disable the Exit Button of UserForm in Excel?
 

How to disable the Exit Button of UserForm in Excel?

How to disable the Exit Button of UserForm in Excel?
 

Hi Alex

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


--
XL2002
Regards

William



"Alex" wrote in message
...
| How to disable the Exit Button of UserForm in Excel?

How to disable the Exit Button of UserForm in Excel?
 

Alex,

Adding to this. There are 4 values for CloseMode

vbFormControlMenu 0 The user has chosen the Close command from the
Control menu on the UserForm.
vbFormCode 1 The Unload statement is invoked from code.
vbAppWindows 2 The current Windows operating environment session is
ending.
vbAppTaskManager 3 The Windows Task Manager is closing the
application.


You may only want to trap value 0, but you may also want to trap 2 and 3.
Probably best not to trap 1, else your code won't be able to close it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"William" wrote in message
...
Hi Alex

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


--
XL2002
Regards

William



"Alex" wrote in message
...
| How to disable the Exit Button of UserForm in Excel?

How to disable the Exit Button of UserForm in Excel?
 

And since a user typically click the close box when they want out of the form, have
it run the CancelButton_Click code, instead of just hanging there.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Bob Phillips wrote:

Alex,

Adding to this. There are 4 values for CloseMode

vbFormControlMenu 0 The user has chosen the Close command from the
Control menu on the UserForm.
vbFormCode 1 The Unload statement is invoked from code.
vbAppWindows 2 The current Windows operating environment session is
ending.
vbAppTaskManager 3 The Windows Task Manager is closing the
application.


You may only want to trap value 0, but you may also want to trap 2 and 3.
Probably best not to trap 1, else your code won't be able to close it.