LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide All Excel Toolbars, Menubars etc when UserForm Loads Shazi Excel Programming 2 June 18th 08 02:30 PM
UserForm Loads Slowly Stratuser Excel Programming 8 September 8th 06 04:47 AM
Hide Userform smokiibear Excel Programming 4 January 18th 05 06:54 PM
Userform.hide / show papou[_7_] Excel Programming 0 September 15th 03 03:12 PM
hide a textbox on a userform? Bill Lunney Excel Programming 2 July 31st 03 08:57 AM


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"