Quit on Error

**dmartinez** · 01-28-2011, 12:40 PM

Hi,

I have a Userform that seems to be working ok so far but I have 2 issues.

1) Whenever I close the userform, I would like for excel to quit. This way, if a user tries to close it like closing a window, rather than using the exit button it won´t send him to VBA.

2) If any error occurs while using this userform, I would like for excel to quit.

Hope you can help.

Thanks in advance.

**royUK** · 01-28-2011, 12:47 PM

Why. That's extreme any other workbooks would be closed possibly losing work.

Closing a userform will not open the VB Editor

**dmartinez** · 01-28-2011, 01:14 PM

I just don´t want for regular users to see other things besides the userform.

is that possible?

thanks

**royUK** · 01-28-2011, 01:27 PM

That's not what you asked. You need to be very careful hiding the application if anything goes wrong then the user ends up running an invisible instance of Excel