arkusM
12-09-2009, 10:01 AM
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
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