Quote:
Originally Posted by Bird_FAT
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
|
And if this doesn't work? I even added in a second command (after the above one) in the workbook_Open procedure (the one from the Help Creating a VBA Procedure for the open event in a workbook)
The second one runs, but the suggestion above doesn't appear to work when coming from a link from SharePoint?
Any other ideas?