Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
HI
Is there a way to Remove the exit button (X) from the UserForm as I only want the form to close if the command buttons are selected. Thanks Noemi |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ron de Bruin posted the following to a similar question:
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 This doesn't remove the Close (what you called Exit) button, but disables it. I haven't tested it, but I suspect that if you remove the MsgBox line the Close button will simply not work. Noemi wrote: HI Is there a way to Remove the exit button (X) from the UserForm as I only want the form to close if the command buttons are selected. Thanks Noemi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Userform problem (Listindex) | Excel Discussion (Misc queries) | |||
Insert Options button doesn't disappear | Excel Discussion (Misc queries) | |||
Add a button to a sheet to open a userform | Excel Discussion (Misc queries) |