Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any way to prevent a user from closing a dialog box by clicking on
the X in the upper right corner? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
try this but make sure you have another method to dismiss the form:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode < 1 Then Cancel = 1 msg = MsgBox("Please Use Cancel Button", 16, "Warning") End If End Sub -- JB "Patrick C. Simonds" wrote: Is there any way to prevent a user from closing a dialog box by clicking on the X in the upper right corner? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
closing read-only without save dialog box appearing | Excel Programming | |||
Opening/Closing workbooks without dialog boxes | Excel Programming | |||
Get the Result of Excel Dialog, when closing excel? | Excel Programming | |||
Dialog box when closing an unsaved spreadsheet | Excel Discussion (Misc queries) | |||
closing excel after closing a workbook | Excel Programming |