Modeless form disappears on deleting sheet
 

Hi,

I am using a modeless form to control my application. Everything works
fine until I use the form to delete a sheet - as soon as this happens,
the form disappears and VBA stops running. Any ideas very much
appreciated. I am using excel 2002

many thanks

Walter

Modeless form disappears on deleting sheet
 

A modeless Userform will disappear immediately as soon as the code within
the Userform is finished running.
You have to re-organize your code to keep the Userform going until you
really want it to go away.

As I recall, my SDI/MDI example at
http://www.standards.com/OhMyWord/VBACodeSnippets.html might show how to do
this.
I have not looked at the code in some time, but it might help you.

--
http://www.standards.com/; Howard Kaikow's web site.
------------------------------------------------
"Walter Martin" wrote in
message om...
Hi,

I am using a modeless form to control my application. Everything works
fine until I use the form to delete a sheet - as soon as this happens,
the form disappears and VBA stops running. Any ideas very much
appreciated. I am using excel 2002

many thanks

Walter