| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximize Sheet1
How does one maximize Sheet1 when opening a workbook? The file has to be
opened through a web page hyperlink, and asking users to press Ctrl+F10 may be too complex. Adjusting the Application.WindowState is similar to adjusting Excel shortcut window size and is NOT what I am looking for. Pressing Ctrl+F10 is provides the effect I am looking for, but I only want to maximize the worksheet and not toggle between two different window sizes. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximize Sheet1
ActiveWindow.WindowState = xlMaximized -- Jim Cone Portland, Oregon USA "SeaFire" wrote in message How does one maximize Sheet1 when opening a workbook? The file has to be opened through a web page hyperlink, and asking users to press Ctrl+F10 may be too complex. Adjusting the Application.WindowState is similar to adjusting Excel shortcut window size and is NOT what I am looking for. Pressing Ctrl+F10 is provides the effect I am looking for, but I only want to maximize the worksheet and not toggle between two different window sizes. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Upload Data from Sheet1 on Local Machine to Sheet1 on LAN | Excel Programming | |||
| Copy from file1 sheet1/file2 sheet1 last blank row | Excel Programming | |||
| [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
| Sheet1.Activate vs Sheet1.Select | Excel Programming | |||
| Why Sheet1 is displayed in modules as sheet1 | Excel Programming | |||
Linear Mode
