Hide Every Thing during UserForm Loads

[Shazi]

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

 

[FSt1]

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]

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









- 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