can i turn off the X button on a userform?

[tonywatsonhelp]

Hi everyone,
I have a userform that pops up halfway through a macro the asks 3 questions and goes to the next part of the macro, all works great,
but if someone clicks the X button it mess everything up,
I've been trying to fine where i put a if X button is pressed is but i cant find anything so is it possible to remove it or switch it off?
Thanks
Tony

 

[dmt32]

Hi,
place following code in your userforms code page

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

Do ENSURE that you have another method to dismiss the form

Dave

 

[tonywatsonhelp]

Brilliant, thank you Dave