Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Oct 8, 6:45 pm, Mekinnik
wrote: How do I remove the close control from the upper right corner of my user form? While it is possible to remove the control completely via API calls and such, it is much easier to just capture the event when the user clicks on the close button and handle it. Private Sub UserForm_QueryClose _ (Cancel As Integer, CloseMode As Integer) If CloseMode = vbFormControlMenu Then MsgBox "Hey, don't do that!!!!" Cancel = True End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add-In Toolbar Control - Removing The Toolbar Question | Excel Programming | |||
Removing hyperlink without removing the font settings /border sett | Excel Programming | |||
Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
Removing calendar control | Excel Discussion (Misc queries) | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |