View Single Post
 
Old 09-24-2009, 08:11 AM
silly_2b_me silly_2b_me is offline Windows XP Office 2007
Novice
 
Join Date: Sep 2009
Posts: 1
silly_2b_me is on a distinguished road
Default

Quote:
Originally Posted by Bird_FAT View Post
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?
Reply With Quote