How to maximize the Excel window?

E

Eric

Does anyone have any suggestions on how to maximize teh excel window whenever
I open excel?
I have set Excel application's property into maximizing window, but I get
many excel files and shortcuts, which property are set into standard. I
cannot individually set each file with maximizing window property, does
anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric
 
D

Dave Peterson

You could create a new workbook and store it in your XLStart folder that
contains a macro that runs each time excel is opened.

Lots of people use the name Personal.xls for this file. And they put all their
macros that they want available when excel opens.

This is the macro:

Option Explicit
Sub Auto_Open()
Application.WindowState = xlMaximized
End Sub

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)
 
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, but it still does not work on
excel file, which is triggered to open by schedule task. For manually opened
approach, it works.
Do you have any suggestions?
Thanks in advance for any suggestions
Eric
 
D

Dave Peterson

What is your security setting for macros? If you stop them from running, then
this macro won't run.
 
E

Eric

It seems to me that not able to maximize window is related to schedule task
function under XP, since when I manually open excel file, it can maximize the
window's size, but the excel window size cannot be maximized if the same file
is opened by schedule task at specific time.
Do you have any suggestions?
Thanks in advance for any suggestions
Eric
 
D

Dave Peterson

Only what I posted before.
It seems to me that not able to maximize window is related to schedule task
function under XP, since when I manually open excel file, it can maximize the
window's size, but the excel window size cannot be maximized if the same file
is opened by schedule task at specific time.
Do you have any suggestions?
Thanks in advance for any suggestions
Eric
 
B

Bob I

The Macro I posted to microsoft.public.excel works with XP and Excel
2007 using Scheduled tasks running under the users account. Perhaps you
are setting something different. Not exactly sure what you are
attempting to accomplish as the whole "Project" is being presented
rather piecemeal and you keep multiposting so threads are scattered all
over. How about telling us what you are actually trying to do.
 
E

Eric

My username is set to be administrator with password.
The macro security is middle, and I already install my local digit cert,
which is created by selfcert.exe to automatically enable the macro as it
opens.
Could you please give me any suggestions why security could relate to my
issue for not able to maximize excel window's size? If I manually open the
excel file, and it can maximize the excel window's size, would schedule task
be the root for looking for solution instead of excel?
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
D

Dave Peterson

Try changing your security settings to low (just temporarily).

Does the automated procedure work then?

If yes, then it's the security setting.

I've never used the certificate stuff, so I'm not sure how it applies to these
kinds of scheduled tasks.
 

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