Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Doesn't Disappear
I have a form with option buttons on it. In the code for one of the option
buttons, there are just two commands, set up like this: Me.Hide Macro1 Macro1 turns screen updating off and then does a lot of other things. But the form doesn't disappear before Macro1 starts. Why is that? I don't want to look at the form frozen on the screen while the macro is running. I want it to disappear as soon as I pick the option. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Doesn't Disappear
Try running the macro after the code that shows the form
Userform1.Show Macro1 not in the userform code -- HTH RP "Stratuser" wrote in message ... I have a form with option buttons on it. In the code for one of the option buttons, there are just two commands, set up like this: Me.Hide Macro1 Macro1 turns screen updating off and then does a lot of other things. But the form doesn't disappear before Macro1 starts. Why is that? I don't want to look at the form frozen on the screen while the macro is running. I want it to disappear as soon as I pick the option. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Doesn't Disappear
try
Unload.Me before running Macro1 "Stratuser" wrote: I have a form with option buttons on it. In the code for one of the option buttons, there are just two commands, set up like this: Me.Hide Macro1 Macro1 turns screen updating off and then does a lot of other things. But the form doesn't disappear before Macro1 starts. Why is that? I don't want to look at the form frozen on the screen while the macro is running. I want it to disappear as soon as I pick the option. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my data disappear? | Charts and Charting in Excel | |||
why workbook disappear ? | Excel Worksheet Functions | |||
I can't get my formulas to disappear | Excel Discussion (Misc queries) | |||
New formula ## does not disappear | Excel Discussion (Misc queries) | |||
Add-Ins disappear | Setting up and Configuration of Excel |