Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any way to prevent someone from closing a dialogbox by clicking the
X in the upper right corner? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I prevent all excel applications from closing at once? | Excel Discussion (Misc queries) | |||
Prevent Excel closing all workbook instances when clicking on "X" | Excel Discussion (Misc queries) | |||
Prevent running macro upon closing Excel | Excel Programming | |||
Prevent workbook closing... | Excel Programming | |||
API to prevent closing Excel | Excel Programming |