How can I avoid form destruction??
 

Hi,

I have a form which requires a lot of initialization, and
I would like to ensure that I only need to do this once;
so the application is responsive once it is done
initializing.

The form is a modal dialog box which closes when it is
OKed or Cancelled. Trouble is, if the user doesn't choose
OK or Cancel, but instead closes the form, then Excel
disposes the object and all state is lost.

How can I stop Excel from destroying the form? Can I
cancel the UserForm_Terminate event? (If so, how is it
done? I'm not fluent in VB...)

Any help would be greatly appreciated. Happy coding!

Dag