Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Prevent DialogBox closing

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 230
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 230
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I prevent all excel applications from closing at once? esg16 Excel Discussion (Misc queries) 1 March 27th 06 12:09 AM
Prevent Excel closing all workbook instances when clicking on "X" Deeptech-NM Excel Discussion (Misc queries) 8 July 4th 05 01:36 PM
Prevent running macro upon closing Excel Deneb Excel Programming 2 February 2nd 05 06:07 PM
Prevent workbook closing... Dave Excel Programming 4 October 25th 04 06:42 PM
API to prevent closing Excel Peter Dao Excel Programming 1 August 12th 03 01:35 AM


All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"