Quote:
Originally Posted by jdanton
I have a hyper link to an Excel file on my webpage. The problem is when Excel opens neither the app nor the file are opened in a maximized state. Is there a way for me to control the state Excel opens in by passing a parameter of some sort or is there a setting I don't see in Excel to tell the file to always open maximized when opened from a browser? It opens maximized when I just open the file by itself (not from the url).
|
try adding
Code:
Option Explicit
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub
to the 'ThisWorkbook' Microsoft Excel Object in the VBA window (it should be visible in the tree on the left and the icon is the same as an excel document)
Then it will Maximize the Excel app upon opening!
Bird