Code to Minimize UserForm

slimpickens · Mar 20th, 2002, 10:00 AM

Hi all,
I have a workbook which minimizes when it is opened, then I have to click on the minimized workbook to show the form. I have started writing some code for a way to search the worksheet - just in case the user makes an error. I have gotten as far as stating what is to be found, the worksheet pops up but the form is still visible andhat I can't get it to minimize. Is there any code I can use to minimize my form and when I have made the amendment to the worksheet, and then code to maximize it again so that I can continue.

Thanks

Carol
Thanks

Al Chara · Mar 20th, 2002, 10:23 AM

Try using the following code:

UserForm1.Hide

UserForm1.Show

Mar 20th, 2002, 10:23 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try using the following code: UserForm1.Hide UserForm1.Show __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 10:00 AM	#1
slimpickens New Member Join Date: Feb 2002 Posts: 35	Hi all, I have a workbook which minimizes when it is opened, then I have to click on the minimized workbook to show the form. I have started writing some code for a way to search the worksheet - just in case the user makes an error. I have gotten as far as stating what is to be found, the worksheet pops up but the form is still visible andhat I can't get it to minimize. Is there any code I can use to minimize my form and when I have made the amendment to the worksheet, and then code to maximize it again so that I can continue. Thanks Carol Thanks