ExcelBanter - Maximize Sheet1

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Maximize Sheet1 (https://www.excelbanter.com/excel-programming/428810-maximize-sheet1.html)

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.

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.