X button question

[Greg B]

I was wondering if I would be able to disble the "x" button only on the
userform called "main"?

If so how do I do it?

Thanks

Greg

 

[dominicb]

Good afternoon Greg B

This is how to do it:

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

Just don't forget to set up a close button, and if you do, don't forge
that you can crash out of a macro using ctrl + Break.

HTH

Dominic

 

[Greg B]

Thanks for that I have the exit and save button just didn't want the
opporunity for the person to lose their work from a little error. I have
all other userforms go back to the main sheet if the X button is pressed.

Thanks again

Greg