View options
 

Hi,
I published the Excel file to my company intranet. It always opens with
minimize view. Therefore I have to click the maximize button to view the
file. Please help me to fix the problem.
Thank you very much in advance.

Chi

View options
 

See if this helps. This code needs to go into the workbook's ThisWorkbook
code module.

In pre-2007 versions of Excel it's easy to get the right-click on the
Excel icon at the very upper-left corner of the Excel window and choose [View
Code] from the drop-down list that appears. Copy and paste the code below
into that module, save and republish the file:

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


Hope it works - haven't tested it as/with an intranet published Excel file.

"Chi" wrote:

Hi,
I published the Excel file to my company intranet. It always opens with
minimize view. Therefore I have to click the maximize button to view the
file. Please help me to fix the problem.
Thank you very much in advance.

Chi