| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window Resize
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Resize Workbook window | Excel Discussion (Misc queries) | |||
| Excel: Expose whole window or at least top resize handles. | 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) | |||
Threaded Mode
