Maximize Sheet1

S

SeaFire

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.
 
J

Jim Cone

ActiveWindow.WindowState = xlMaximized
--
Jim Cone
Portland, Oregon USA



"SeaFire"
<[email protected]>
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

replacing built in keyboard shortcuts with my macros? 2
Help for VBA NooB 6
Opening maximized 6
Maximize Form Issue 1
C# IDE Shortcutkeys 1
Maximize Windows in Background 2
multiple workbooks in window 1
Form Sizing 7

Top