MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Maximising Excel on Opening

Posted by paulie on February 06, 2002 7:36 AM

When i open excel by double clicking an excel file, excel is never maximised, just covers half the available screen, is there anyway to make it maximise the sheet and excel when excel opens?, maybe a macro command?.

Thanks for any help

Posted by Juan Pablo G. on February 06, 2002 7:52 AM

Put this in the Workbook module

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

Juan Pablo G.

Posted by paulie on February 06, 2002 8:34 AM

I've put that in the workbook, with an existing module to close immediately auto save, the maximise command seems to run everyother time i open excel?, any idea why?, i've only ever put 1 sub in a workbook before, anything special i need to do to add 2 sub modules?, this si what i have in the workbook now:

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

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
End Sub

Posted by Andrew on February 06, 2002 11:16 AM

Posted by Andrew on February 06, 2002 11:22 AM

What about opening to a specific location?

Err, sorry for the redundancy. My finger slipped. Anyway, is there a way to open excel to a predetermined location on the screen? I'm one of those people who likes his Start bar on the top of the screen, and every time I open Excel, the active title bar is hidden behind the start bar. Whatever shall I do?