MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Maximizing Excel and the workbook in it

Posted by RoB on October 04, 2001 8:40 PM

Is there a macro that will maximize the excel application (assuming its open and not maximized) AND the workbook when opening an excel file (workbook_open() )? Thanks :)

Posted by Jerid on October 05, 2001 5:24 AM

Put this in your ThisWorkbook module

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