Getting Excel 2007 Spreadsheets to Open Maximized

  • Thread starter Thread starter Jim Turner
  • Start date Start date
J

Jim Turner

We save a lot of info for our users in spreadsheets on a server. The
addresses of the spreadsheets are linked on a web page so the users can
easily find them.

The problem is that no matter how we save the spreadsheet, when the user
clicks the web link and the spreadsheet opens, it is always Restored
Undocked. For some users the sheet tabs are off the bottom of the screen and
I've seen on where the sheet only had a little corner showing. Not all of
our people are savvy enough to understand how to get the spreadsheet
maximized when the upper right hand buttons aren't showing. Usually, their
problem is not with maximizing the Excel program; itr is just with the
spreadsheet itself.

Is there something we can do when saving the spreadsheet that will force it
to come up in Excel maximized?
 
Hi,

Try adding this code to the thisWorkbook object in the VBA

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized
End Sub

If these are Excel 2007 files you will need to save it a macro enabled, xlsm
Alternatively you could put this code into the Workbook_BeforeSave event.
 
ShaneDevenshire said:
Try adding this code to the thisWorkbook object in the VBA

Private Sub Workbook_Open()
    ActiveWindow.WindowState = xlMaximized
End Sub

If these are Excel 2007 files you will need to save it a macro enabled, xlsm
Alternatively you could put this code into the Workbook_BeforeSave event.
Click to expand...
....

And if for security reasons workbooks stored on the OP's server can't
be macro enabled, what then? If these workbooks were being opened from
http hyperlinks, would macros even be enabled no matter what the file
type?

A more robust solution may be to add application events to every
user's Personal.xls[m] file that would maximize document windows when
any file is opened.
 
Back
Top