Minimize a form
 

I'm running a spreadsheet form modeless.

While focus is being given to the spreadsheet, is there a
way before the focus changes to the spreadsheet, for the
form to be minimized, and then automatically maximize
itself once the macro in question finishes?

Thanks,


Bruce

Minimize a form
 

Bruce

Userform1.Hide
'Macro code here
Userform1.Show

Is that what you're after?

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Bruce Roberson" wrote in message
...
I'm running a spreadsheet form modeless.

While focus is being given to the spreadsheet, is there a
way before the focus changes to the spreadsheet, for the
form to be minimized, and then automatically maximize
itself once the macro in question finishes?

Thanks,


Bruce

Minimize a form
 

Yes, that looks like it would serve my purpose.

Thanks
-----Original Message-----
Bruce

Userform1.Hide
'Macro code here
Userform1.Show

Is that what you're after?

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Bruce Roberson" wrote in
message
...
I'm running a spreadsheet form modeless.

While focus is being given to the spreadsheet, is there
a
way before the focus changes to the spreadsheet, for the
form to be minimized, and then automatically maximize
itself once the macro in question finishes?

Thanks,


Bruce


.