Hi all,

I have the current build Excel O365 (2105) on a large 3840x2160 second monitor.

I am using vba to resize the Excel application and a user form with a menu at the side of the main screen.

The main application is maximised and the height and width of 1284 and 2314.8 points respectively is saved.

The Excel application window state is changed to xlNormal and moved to the correct location on the screen.

The width and height are then set accordingly, but no matter how large the w and h are set, vba limits .width to 1156.2 and height to 655.2, roughly a quater of the full screen.

Application.WindowState = xlMaximized

dblLeftPosition = Application.Left
dblTopPosition = Application.Top

WindowX = ActiveWindow.Width
WindowY = ActiveWindow.Height

With ActiveWindow
            .WindowState = xlNormal
            .Top = dblTopPosition
            .Left = dblLeftPosition + NavWidth
            .Height = WindowY    '(after execution, .Height = 655.2 and WindowY = 1284)
            .Width = WindowX - NavWidth
End With
The user form is able to sized to the maximised screen size with no issues.

Has anyone come across this issue before?

Thanks!.