Closing a userform you disabled 'X' on... or stopping the macro

[Smurlos]

Hi

I used a piece of code to disable being able to close a userform with the conventional "X" but in this particular userform I also forgot to add a 'Cancel' button to close the userform...

Added to this, when I tested, I did not have VB open, so I can't enter break mode and stop the macro... and I've not saved recently...

Is there a way I can stop this macro running without closing the whole program and losing all my work? :-(

Thanks

[royUK]

have you tried the Esc button?

Personally,I find UserForms with the X disabled annoying.

[Smurlos]

I have indeed.

I did a little search. Apparently, control and BREAK on your keyboard does the trick nicely :-) Brings up VB so that you can reset your project.

As for the X being disabled. This is because I work with interfering colleagues who like to go in and alter things manually but they do not do so in the correct format i.e. you end up with dates like 12/1/10 instead of "12/01/2010" etc.

Thanks
Regards

[Palmetto]

As for the X being disabled. This is because I work with interfering colleagues who like to go in and alter things manually but they do not do so in the correct format i.e. you end up with dates like 12/1/10 instead of "12/01/2010" etc.

I agree with royUK on disabling the "X". However, disabling the "X" does not prevent incorrect entries.

If you want to control the format of entries then use code to check the entry or provide a calendar control to select the dates and format the selection accordingly.

Further, apply protection to the VBA project to prevent tampering.