Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Userform Deactivate Button
I'm trying to remove the deactivate button from a Userform's button bar... is
this possible and how would I go about it? Would be greatful for any help with this. Thanks Martin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Userform Deactivate Button
Easier is to just manage closing of the form with the queryclose event:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) 'Prevent user from closing with the Close box in the title bar. If CloseMode < 1 Then Cancel = 1 UserForm1.Caption = "Use the close button" End Sub If you still want to remove the X button, then you need to use the Windows API. See Stephen Bullen's site formfun.zip http://www.bsmltd.ie in the links on the left, go to the excel page -- Regards, Tom Ogilvy "Martin" wrote in message ... I'm trying to remove the deactivate button from a Userform's button bar... is this possible and how would I go about it? Would be greatful for any help with this. Thanks Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use the X button on a userform | Excel Discussion (Misc queries) | |||
Remove UserForm | Excel Programming | |||
The userform X button | Excel Programming | |||
UserForm Button Help | Excel Programming | |||
button to launch my userform | Excel Programming |