Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo Box text and Controls changing size on Monitor change | Excel Worksheet Functions | |||
how to set up a page to display full screen on any size monitor | Excel Discussion (Misc queries) | |||
Position of Userform in other scrrens/monitor problem | Excel Programming | |||
resize userform image to fit on any monitor | Excel Programming | |||
Arranging 3 windows ... Regardless of Monitor Size | Excel Programming |