Results 1 to 2 of 2
Thread: User Form Hide Problem
2001-06-21, 03:29 #1ralph_daviesGuest
User Form Hide Problem
In Excel 2000 when I call another sub from a button on a user Form, I can not seem to imediatly Hide the Form.
Putting .Hide before or after the call in the button macro makes no difference.
Putting the .Hide in the called routine also makes no difference.
The Form stays visible until all code is run.
How can I avoid this behaviour ????
2001-06-21, 13:16 #2
- Join Date
- Jan 2001
- South Carolina, USA
- Thanked 0 Times in 0 Posts
Re: User Form Hide Problem
1- Do you have ScreenUpdating set to false? If so, set it to True before hiding the form.
2- Put a DoEvents statement after the .Hide to release the processor so that the screen can be updated.Legare Coleman