How to prevent the closure of a UserForm

[Romoluzzi]

Hi all,
I'm preparing a sheet which has to be used by not very skilled users.
For this reason, I prepared dedicated UserForms (see example attached) to input data but I would not permit the user to "close" the forms simply by clicking on the red-upper-right-corner "X", without following correctly my procedure.

I immagine this is possible by an appropriate code in loading the form.

Can anyone help?
As usual I do appreciate in advance your promt and professional assistance.

[royUK]

Try this

Please Login or Register  to view this content.

[Colin Legg]

You can prevent it closing via the X button by adding the following event handler to the userform's code module:

Please Login or Register  to view this content.

[edit]RoyUK already gave the same answer but I cannot soft delete this post.[/edit]

[Romoluzzi]

As expected, you are the BEST!
Thank you so much RoyUK and Colin Legg