View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shazi Shazi is offline
external usenet poster
 
Posts: 74
Default Hide Every Thing during UserForm Loads


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