View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
Posts: 320
Default is preventing the appearence of the close symbol possible?

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.