simora
06-16-2017, 05:21 PM
I have 2 Excel User Forms.
If I call the 2nd Form from the first like this
Unload Me
UserForm1.Show
Application.WindowState = xlMinimized
And then try to show Excel from this UserForm1 Like this
If Application.WindowState = xlMinimized Then
Application.WindowState = xlMaximized
OR
ActiveWindow.WindowState = xlNormal
Application.Visible = True
No matter what I've tried, this form will NOT open the Excel document as Normal , or anything else.
Any ideas as to why this does NOT work ?
Using Office 2007
If I call the 2nd Form from the first like this
Unload Me
UserForm1.Show
Application.WindowState = xlMinimized
And then try to show Excel from this UserForm1 Like this
If Application.WindowState = xlMinimized Then
Application.WindowState = xlMaximized
OR
ActiveWindow.WindowState = xlNormal
Application.Visible = True
No matter what I've tried, this form will NOT open the Excel document as Normal , or anything else.
Any ideas as to why this does NOT work ?
Using Office 2007