To "restore" a window you use code like this:

ActiveWindow.WindowState = xlNormal

To position it you use the window's Left, Top, Width and Height properties.

--
Jim Rech
Excel MVP
"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