Prevent DialogBox closing
 

Is there any way to prevent someone from closing a dialogbox by clicking the
X in the upper right corner?

Prevent DialogBox closing
 

Do you think dialog box(for example message box) or form?
For form, I know how solvate your problem, but I'am afraid for dialog
box it isn't possible. Contact me on e-mail.
Dejv


--
Dejv
------------------------------------------------------------------------
Dejv's Profile: http://www.excelforum.com/member.php...o&userid=27784
View this thread: http://www.excelforum.com/showthread...hreadid=473277

Prevent DialogBox closing
 

You might have to use a Userform to mimic the functionality of the dialog
box, then use this from J-Walk:

Private Sub UserForm_QueryClose _
(Cancel As Integer, CloseMode As Integer)
' Prevents use of the Close button
If CloseMode = vbFormControlMenu Then
MsgBox "Clicking the Close button does not work."
Cancel = True
End If
End Sub


"Patrick Simonds" wrote in message
...
Is there any way to prevent someone from closing a dialogbox by clicking
the X in the upper right corner?

Prevent DialogBox closing
 

Having the answer here in the forum, where the question originated, might
be preferable.


"Dejv" wrote in message
...

Do you think dialog box(for example message box) or form?
For form, I know how solvate your problem, but I'am afraid for dialog
box it isn't possible. Contact me on e-mail.
Dejv


--
Dejv
------------------------------------------------------------------------
Dejv's Profile:
http://www.excelforum.com/member.php...o&userid=27784
View this thread: http://www.excelforum.com/showthread...hreadid=473277