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

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

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


.