Screen Area Resolution

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
 
G

GJones

cj;

Try this sub

Sub try()

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


Thanks

Greg
 
B

Big Chris

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.
 
T

Tom Ogilvy

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.
 
Top