Ryan,

A simple record of a macro produced the following code:
see if this helps...

''''''''''''''''
Application.WindowState = xlNormal
Application.Left = 155.5
Application.Top = 35.5
Application.Width = 700
Application.Height = 500
'''''''''''''''''''''''''''''''''''''''

--
steveb
(Remove 'NOSPAM' from email address if replying direct)


"Ryan" wrote in message
...
I have a command button in a spreadsheet that opens up another
spreadsheet. I want to know how I can set it so that when the second
spreadsheet opens, I can set the size of the window it is in, or at least
have it not maximized or minimized.

Ryan