Workbooks Opening Maximized

[mdalby]

Sometimes when I open workbooks they do not automatically open
maximized. It is frustrating.

I click on the left hand corner of the workbook and miximize and save
the workbook but it still opens the next time with the corners not
fully extended in Excel.

Help.

Excel 2003
XP

Thanks,

MD

 

[mdalby]

bump to top of list to see if someone has an answer..

 

[Dave Peterson]

I think excel likes to look at the current layout. If you have your active
window maximized, then xl will open the next one maximized.

If your activewindow is less than maximized, then it'll open the next one less
than maximized.

So you could try maximizing the activewindow, then file|open your workbook.

===
One the other hand, you could always force the windows to be maximized via a
macro:

Option Explicit
Sub auto_open()
Application.WindowState = xlMaximized
ActiveWindow.WindowState = xlMaximized
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm