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: 47
Default Auto-size the UserForm with Monitor Configuration

Hi Community !

I have an UserForm that will fill the whole screen.
I don't want to show the sheet as "background". I have my company logo as
background with many CommandButtons on the UserForm.

The problem is that when I open the file in my laptop, due to the laptop
configuration, it gets smaller.

Question is:

Is there any command to "auto-size" this UserForm in anywhere I open this
file?

Another question:

Can someone give the command for Print View by using a commandbutton? I have
this:

Private Sub CommandButton6_Click()
ActiveWindow.SelectedSheets.PrintPreview
End Sub

But it bugs excel freezing all panes.

Thank you in advance !!!
 
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
Combo Box text and Controls changing size on Monitor change Richhall[_2_] Excel Worksheet Functions 0 January 12th 10 12:38 PM
how to set up a page to display full screen on any size monitor davey139 Excel Discussion (Misc queries) 1 May 24th 09 08:12 AM
Position of Userform in other scrrens/monitor problem LuisE Excel Programming 0 December 1st 07 08:50 PM
resize userform image to fit on any monitor timspier[_7_] Excel Programming 1 August 5th 06 06:44 AM
Arranging 3 windows ... Regardless of Monitor Size monir Excel Programming 4 March 18th 06 07:51 PM


All times are GMT +1. The time now is 05:40 PM.

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"