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
.