Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows form Protected Sheet | Excel Discussion (Misc queries) | |||
bottom sheet tab disappears | Excel Worksheet Functions | |||
spread sheet disappears | Excel Discussion (Misc queries) | |||
Modeless userform | New Users to Excel | |||
Modeless form for user interaction | Excel Programming |