View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eddie_SP[_2_] Eddie_SP[_2_] is offline
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 !!!