I usually divert the click to the Cancel button, since obviously the
user wants out.

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then cmdCancel_Click
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Bob Umlas wrote:

Not as far as I know, but you CAN disable its functionality:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then Cancel = True
End Sub

Bob Umlas
Excel MVP

"Marta" wrote in message
...

Hi,
Can I prevent the appearence of the "X" symbol (for closing the window) on

a

user form via a macro?. I'll be happy to hear any answers. Thanks in

advance

whoever creates a solution.