Re-post: How to maximize the Excel window?

E

Eric

I set schedule to open excel file, when it opens, the excel window's size is
not maximized, and I have tried your approach, for manually opened
approach, it works, but it still does not work on opening excel file, which
is triggered by schedule task. Do you have any suggestions?
Thanks in advance for any suggestions
Eric
 
G

Gary Keramidas

try putting the code in the thisworkbook module

Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub
 
E

Eric

I have set the property of Excel with maximizing window, when excel is
manually opened, it shows in maximized window's size, but when schedule task
activates to open excel file, the excel window's size is not maximized. On
the other hands, the given coding works fine, if Excel is opened manually, so
the issue is when excel is opened and triggered by schedule task, Excel
cannot be maximized window's size.
Do you have any suggestions?
Thanks in advance for any suggestions
Eric
 
D

Dave Peterson

Check your other thread.
I set schedule to open excel file, when it opens, the excel window's size is
not maximized, and I have tried your approach, for manually opened
approach, it works, but it still does not work on opening excel file, which
is triggered by schedule task. Do you have any suggestions?
Thanks in advance for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top