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.

Look at the formfun.zip download from Stephen Bullen's site

http://www.bmsltd.ie

go to the excel page.

--
Regards,
Tom Ogilvy

"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.

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.

Thanks to Tom and Bob,
I'll give both a try...

"Bob Umlas" wrote in message
...
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.

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.