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

Word 2003 won't maximize properly 0
Problem Opening Multiple Access Databases 2
How to prevent a document from opening maximized 0
New Editing Problems in XP Home - Office 2003 - Screwed up formatt 5
How do I make a table open automatically to MAXIMIZE size? 1
Opening maximized 6
Toggle styles on/off in restricted Word 2007 template 4
replacing built in keyboard shortcuts with my macros? 2

Top