Minimize a form

[Bruce Roberson]

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

 

[Dick Kusleika]

Bruce

Userform1.Hide
'Macro code here
Userform1.Show

Is that what you're after?

 

[Bruce Roberson]

Yes, that looks like it would serve my purpose.

Thanks