How can I disable the close button on and Excel Form 1

[Pedrowedro]

Hi I have been trying to disable the close button in an excel form with no luck.

If it is not possible to disable it, is it possible to catch the code as it runs upon the event of the close button being pressed.

Thanks

 

[CBasicAsslember]

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
      Cancel = Not CloseMode
End Sub

 

[Pedrowedro]

Thanks CBasicAsslember that worked a treat!