hi
you can hide excel and keep the form visible when you load your form.

application.visible = false

the form would appear in the middle of your desktop theme.
then when you close your form..

application.visible = true

this will make excel visible again.

regards
FSt1


"Shazi" wrote:


Hi,

I prepared one userform showing detail from worksheet. when it loads
then worksheet is displayed behind with all toolbars and menubars.

I want to display userform only without viewing worksheets and any
thing.
I used this command


ActiveWindow.WindowState = xlMinimized

but still active sheet is visible in the left corner of the bottom.
how to fix this problem

Regards.

Shahzad