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


-----Original Message-----
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
.

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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

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.

--
Regards,
Tom Ogilvy


CJ wrote in message
...
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