.WindowState = xlNormal hangs up in Excel 2016

Brian Feth

New Member
Joined
May 21, 2017
Messages
15
Windows 10, Excel 2016; This worked in Excel 2010 but hangs up in Excel 2016 after the ".WindowState = xlNormal" statement ant ",Top = 1" (but not always). Anyone know why?

With ActiveWindow
.WindowState = xlNormal
.Top = 1
.Left = 1
.Height = Application.UsableHeight
.Width = Application.UsableWidth * 0.62
End With
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
9,899
have you tried re-recording the expected actions in 2016 to see what is being written
 

Forum statistics

Threads
1,082,550
Messages
5,366,257
Members
400,880
Latest member
aforte

Some videos you may like

This Week's Hot Topics

Top