Thread: Minimize a form
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bruce Roberson Bruce Roberson is offline
external usenet poster
 
Posts: 47
Default 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



.