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