Manipulate VBE Window

[arkusM]

I have found and have been using the following code to set my Excel application window size on a dual screen setup.


Sub VBAVirtualScreen()
With Application
.WindowState = xlNormal
.Left = 0
.Top = 0
.Width = GetSystemMetrics(SM_CXVIRTUALSCREEN) - 1787
.Height = GetSystemMetrics(SM_CYVIRTUALSCREEN) - 275
End With
End Sub


I would like to set the VBE window size as well... however I cannot seem to find the appropriate code. I have tried using VBIDE or Application.VBE but with no success :banghead: . The "help" file on Application is no help.

Cheers.
Mark

[Bob Phillips]

Have youtried



Sub VBAVirtualScreen()
With Application.VBE
.WindowState = xlNormal
.Left = 0
.Top = 0
.Width = GetSystemMetrics(SM_CXVIRTUALSCREEN) - 1787
.Height = GetSystemMetrics(SM_CYVIRTUALSCREEN) - 275
End With
End Sub

[arkusM]

Yes i did. I just went and reran the macro after reopening Excel to get the error code and a different error came up after running the code for the "first" time after opening. This time I got a "Programmictic access to Visual Basic Project is not trusted" error.

Other wise I get a "Method 'VBE' of object '_Application' failed"

[Bob Phillips]

To overcome thgis, goto Tools>Macro>Security, select the Trusted Publishers tab, and check it.

[arkusM]

I Trusted Access to VB project now I get:
Runtime error '438':
Object doesn't support this propery or method

I have "Microsoft Visual Basic for Apps Extensibiility 5.3" ref'd

[arkusM]

Got It! Needed to add the red bits.


With Application.VBE.MainWindow
.WindowState = vbext_ws_Normal
End With



Thanks for the help xld you got me going the right directions, well at least stopped me from spinning in circles!! LOL