How to maximize the Excel window?

Eric · External Since: Mar 05, 2006 Posts: 606

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

Dave Peterson · External Since: Jul 08, 2005 Posts: 16264

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.)

Eric wrote:
>
> 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

--

Dave Peterson

Eric · External Since: Mar 05, 2006 Posts: 606

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

"Dave Peterson" wrote:

> 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.)
>
> Eric wrote:
> >
> > 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
>
> --
>
> Dave Peterson
> .
>

Dave Peterson · External Since: Jul 08, 2005 Posts: 16264

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

Eric wrote:
>
> 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
>
> "Dave Peterson" wrote:
>
> > 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.)
> >
> > Eric wrote:
> > >
> > > 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
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson

Eric · External Since: Mar 05, 2006 Posts: 606

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

"Dave Peterson" wrote:

> What is your security setting for macros? If you stop them from running, then
> this macro won't run.
>
> Eric wrote:
> >
> > 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
> >
> > "Dave Peterson" wrote:
> >
> > > 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.)
> > >
> > > Eric wrote:
> > > >
> > > > 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
> > >
> > > --
> > >
> > > Dave Peterson
> > > .
> > >
>
> --
>
> Dave Peterson
> .
>

Bob I · External Since: Dec 30, 2004 Posts: 633

Seems Eric is multi-posting in microsoft.public.excel also.

Dave Peterson wrote:

> What is your security setting for macros? If you stop them from running, then
> this macro won't run.
>
> Eric wrote:
>
>>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
>>
>>"Dave Peterson" wrote:
>>
>>
>>>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.)
>>>
>>>Eric wrote:
>>>
>>>>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
>>>
>>>--
>>>
>>>Dave Peterson
>>>.
>>>
>
>

Dave Peterson · External Since: Jul 08, 2005 Posts: 16264

Only what I posted before.

Eric wrote:
>
> 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
>
> "Dave Peterson" wrote:
>
> > What is your security setting for macros? If you stop them from running, then
> > this macro won't run.
> >
> > Eric wrote:
> > >
> > > 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
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > 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.)
> > > >
> > > > Eric wrote:
> > > > >
> > > > > 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
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > > .
> > > >
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson

Bob I · External Since: Dec 30, 2004 Posts: 633

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.

Eric wrote:

> 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
>
> "Dave Peterson" wrote:
>
>
>>What is your security setting for macros? If you stop them from running, then
>>this macro won't run.
>>
>>Eric wrote:
>>
>>>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
>>>
>>>"Dave Peterson" wrote:
>>>
>>>
>>>>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.)
>>>>
>>>>Eric wrote:
>>>>
>>>>>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
>>>>
>>>>--
>>>>
>>>>Dave Peterson
>>>>.
>>>>
>>
>>--
>>
>>Dave Peterson
>>.
>>

Eric · External Since: Mar 05, 2006 Posts: 606

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

"Dave Peterson" wrote:

> What is your security setting for macros? If you stop them from running, then
> this macro won't run.
>
> Eric wrote:
> >
> > 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
> >
> > "Dave Peterson" wrote:
> >
> > > 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.)
> > >
> > > Eric wrote:
> > > >
> > > > 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
> > >
> > > --
> > >
> > > Dave Peterson
> > > .
> > >
>
> --
>
> Dave Peterson
> .
>

Dave Peterson · External Since: Jul 08, 2005 Posts: 16264

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.

Eric wrote:
>
> 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
>
> "Dave Peterson" wrote:
>
> > What is your security setting for macros? If you stop them from running, then
> > this macro won't run.
> >
> > Eric wrote:
> > >
> > > 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
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > 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.)
> > > >
> > > > Eric wrote:
> > > > >
> > > > > 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
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > > .
> > > >
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson