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
mdalby wrote:
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
------------------------------------------------------------------------
mdalby's Profile: http://www.excelforum.com/member.php...fo&userid=7055
View this thread: http://www.excelforum.com/showthread...hreadid=390202
--
Dave Peterson