Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window Resize
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Resize Workbook window | Excel Discussion (Misc queries) | |||
How to resize Data Form dialog window? | Excel Worksheet Functions | |||
Need to resize a worksheet window | Excel Discussion (Misc queries) | |||
Resize the workbook window is impossible | Excel Discussion (Misc queries) | |||
Window Resize | Excel Programming |