In VBA, is there any way of removing the little X buttons off the dialog
boxes top right hand corner??


--
pspyve
------------------------------------------------------------------------
pspyve's Profile: http://www.excelforum.com/member.php...o&userid=30656
View this thread: http://www.excelforum.com/showthread...hreadid=503180

p,

Do you mean dialog box or do you mean userform?
If a userform then look at the QueryClose event for the form.
You can use that to prevent the form from closing.

Jim Cone
San Francisco, USA


"pspyve"
wrote in message
In VBA, is there any way of removing the little X buttons off the dialog
boxes top right hand corner??
pspyve

Hi
This won't remove it, but it will disable it

'Sub suggested in Green, page190
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As
Integer)
Application.EnableEvents = False
If CloseMode = vbFormControlMenu Then
MsgBox "Please use only the Cancel button", vbCritical, "This
cancel is disabled"
Cancel = True
End If
Application.EnableEvents = True
End Sub

regards
Paul

I know there was an API that removed it - using 97 - and probably would
work for later versions but not something I would recommend unlessyou
know what you are doing. and really need to do this

I am away from home and haven't got the code on me.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=503180