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

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

On Jun 24, 12:49*am, FSt1 wrote:
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- Hide quoted text -

- Show quoted text -

Hi,

Thanks for replying, but I dont want to hide Excel for the UserForm,
because when excel hide, then all the things on the desktop are
visible behind the UserForm. I want my userform will display with Blue
Background and nothing else. is it possible?

waiting for your reply.

Shahzad