Hi Ayo,

Try Stephen Bullen's:

NoCloseButton.zip
http://www.oaltd.co.uk/Excel/Default.htm





---
Regards.
Norman


"Ayo" wrote in message
...
I don't want to disable the icon, I want to hide it completely so that the
userform looks like a splash screen.

"Norman Jones" wrote:

Hi Ayo,

To hide the Userform's X icon, try
downloading Stephen Bullen's
FormFun.zip file at:

Stephen Bullen's Excel Page
http://www.oaltd.co.uk/Excel/Default.htm

To disable the icon, in the Userform
module try something like:

'========
Private Sub UserForm_QueryClose( _
Cancel As Integer, _
CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
End If
End Sub
'<<=========

However, preferable would be the
following version wh9ich redirects
the icon to the Userform's cbExit
button: this allows any code linked
to the close button to run, without
annoying the typical user, who
would expect thw icon to close the
form.

'========
Private Sub UserForm_QueryClose( _
Cancel As Integer, _
CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Call cbExit_Click
End If
End Sub
'<<=========



---
Regards.
Norman


"Ayo" wrote in message
...
How do I turn-off the X "Close button" on a form so that it looks like
a
dialog form