ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Maximize VBE Window? (https://www.excelbanter.com/excel-programming/447923-maximize-vbe-window.html)

Charlotte E.[_3_]

Maximize VBE Window?
 
Hi,


I know to open/show the VBE window by VBA with...

Application.VBE.MainWindow.Visible = True

....but is it also possible to ensure that it is maximized?


Thanks,

CE

isabelle

Maximize VBE Window?
 
hi,

Application.VBE.MainWindow.WindowState = 2

isabelle


Le 2013-01-02 16:09, Charlotte E. a écrit :
Hi,


I know to open/show the VBE window by VBA with...

Application.VBE.MainWindow.Visible = True

...but is it also possible to ensure that it is maximized?


Thanks,

CE


Charlotte E.[_3_]

Maximize VBE Window?
 
Thanks :-)

Den 03.01.2013 01:27, isabelle skrev:
hi,

Application.VBE.MainWindow.WindowState = 2

isabelle


Le 2013-01-02 16:09, Charlotte E. a écrit :
Hi,


I know to open/show the VBE window by VBA with...

Application.VBE.MainWindow.Visible = True

...but is it also possible to ensure that it is maximized?


Thanks,

CE



All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com