Workbooks Opening Maximized
 

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

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


--
mdalby
------------------------------------------------------------------------
mdalby's Profile: http://www.excelforum.com/member.php...fo&userid=7055
View this thread: http://www.excelforum.com/showthread...hreadid=390202

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