Disable UserForm Close Control

[dtaylor]

Hello All,
In access you can specify if a form contains the close 'X' in the top right hand corner via form properties. Is there a a similar optio in Excel? I cannot find it is properties of a userform. If this is not an option in the properties window can this be done via VBA?

Thanks

Dan

 

[AcctgGuy]

Dan,

This can be done via VBA...here's the code.

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
Me.Caption = "Click the CommandButton to close Me!"
End If
End Sub

That should work for you...
Cheers

 

[dtaylor]

thats the trick - thank you...

 

[AcctgGuy]

No problem...

 

[Juan Pablo González]

You can also look here:

http://www.bmsltd.ie/Excel/Default.htm

the 'FormFun.zip' file shows how to hide the X button.

 

[AcctgGuy]

Thanks Juan, looks very interesting!