| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Forms Exit Errors
jordanctc
This should prevent the user fron using the "X". Private Sub userform_QueryClose(Cancel As Integer, CloseMode A Integer) Application.ScreenUpdating = False If CloseMode = vbFormControlMenu Then MsgBox "You Have to use the Exit Button to close!" Cancel = True End If End Sub HTH Charle -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exit Sub | Excel Discussion (Misc queries) | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
| Calling Forms from Forms - Exit problems | Excel Programming | |||
| If a called sub exit, how to the caller exit right away? | Excel Programming | |||
Threaded Mode
