Screen Area Resolution

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

I have an "Auto Open" macro set up that does certain
things when a user opens a file. Now, I would like them
to have the same screen area that I use (1152 by 864
pixels) so all the buttons and such fit on one screen.
Does anyone know the code how to do this, if there is a
way? It would just make it easier and users would
not "miss" anything by not having to scroll up and down
the spreadsheet.

Thanks for any response you might have.

-CJ
 
cj;

Try this sub

Sub try()

Application.WindowState = xlNormal
Application.Width = 520.5
Application.Height = 369
End Sub


Thanks

Greg
 
I'm not an expert, but this code works for me....

Sheets("Introduction").Select
Range("A1:p1").Select
ActiveWindow.Zoom = True

A1:P1 will then fill the whole width of the screen.

HTH

Chris.
 
Have you used other applications that changed your screen resolution? This
would be very bad behavior. You need to change your application to be
usable at any screen resolution.
 
Back
Top