Is there an onload event in Excel?

L

loric

I am trying to make an excel file maximize when the page is loaded. I
don't see an onload event, does anyone know if there is one?

Lori
 
G

Guest

If you right click on the Excel icon in the upper left corner of the Excel
window and select View code it wil take you to ThisWorkbook in the VBE. There
are two drop down's just above the code window. Change the one on the left to
workbook and the other to OnOpen...
 
D

Dave Peterson

The dropdown on the right should be named "Workbook_Open" (not OnOpen).

Your (the OP's) code could look like:

Option Explicit
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
ActiveWindow.WindowState = xlMaximized
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top