Quote:
Originally Posted by 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
|
Hi Eric,
Try this in your perosnal.xls (your personal macro book) which excutes whenever excel runs
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub
If it works, please type "yes".