Can't programmatically maximize VB editor

Question

In Word 2003, this line:

VBE.ActiveWindow.WindowState = vbext_ws_Maximize

used to work to maximize the VBE. It doesn't seem to anymore, in 2010.  The line doesn't throw an error, it just gets ignored..References include VBA Extensibility (5.3).

Answer 1

Forget the reference, the reference is only related for the "vbext_ws_Maximize" constant.

You said: "the line is ignored", that means that your settings trust the VBA project is set properly, otherwise you'll get an RTE 6068.

Well, your description can only mean that the line is executed and works, but not in the way that you expected. .-)

Please execute this sub:

Sub Test()

  VBE.ActiveWindow.WindowState = 0

End Sub

As you see, the VBE is a multiple windows application, like Excel. With this property you can only size the window inside the VBE, not the VBE itself.

If you want to maximize the VBE itself, you must use the MainWindow object instead.

Sub Test()

  VBE.MainWindow.WindowState = vbext_ws_Maximize

End Sub

Andreas.

Answer 2

Yes, that is the file's size.

Answer 3

Hi,

OK, please check if the size of file VBE6EXT.OLB is 40.0 KB (40, 960 bytes)?

Library VBIDEPath:    C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLBDescription:    Microsoft Visual Basic for Applications Extensibility 5.3

If not, try to copy from another PC.

Best Regards,

Cristin Yan

Answer 4

Cristin - Your pictures don't show (in any of 3 browsers); but yes, that box is checked in the Macro Settings in the program options.

Answer 5

Hi,

Please see if Trust access to the VBA project object model is checked according to the pictures below:

Cheers,

Cristin Yan