ShowModal (Excel 2000)

[HUHandEH]

Hi all
Is there a way to show a form with the Excel Application Minimized, Or should I be using VB6?

Thanks
Darryl.

[HansV]

There may be a trick using Windows API functions., but as far as I know it's not possible using Excel VBA only.

[LegareColeman]

I don't think so, the userform would be minimized with Excel. You can do this though:

<pre> Application.Visible = False
UserForm1.Show
</pre>

[HUHandEH]

Where would I insert that code?

[LegareColeman]

Where you want to show the userform without Excel being visible. And someplace before the userform goes away, you better have:

<pre> Application.Visible = True
</pre>