If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to maximize the Excel window?
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 |
#2
|
|||
|
|||
How to maximize the Excel window?
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 he 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 |
#3
|
|||
|
|||
How to maximize the Excel window?
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 he 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 . |
#4
|
|||
|
|||
How to maximize the Excel window?
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 he 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 |
#5
|
|||
|
|||
How to maximize the Excel window?
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 he 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 . |
#6
|
|||
|
|||
How to maximize the Excel window?
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 he 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 . |
#7
|
|||
|
|||
How to maximize the Excel window?
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 he 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 |
#8
|
|||
|
|||
How to maximize the Excel window?
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 he 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 . |
#9
|
|||
|
|||
How to maximize the Excel window?
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 he 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 . |
#10
|
|||
|
|||
How to maximize the Excel window?
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 he 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 |
Thread Tools | |
Display Modes | |
|
|