| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there an onload event in Excel?
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 -- loric ------------------------------------------------------------------------ loric's Profile: http://www.excelforum.com/member.php...o&userid=33920 View this thread: http://www.excelforum.com/showthread...hreadid=539113 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there an onload event in Excel?
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... -- HTH... Jim Thomlinson "loric" wrote: 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 -- loric ------------------------------------------------------------------------ loric's Profile: http://www.excelforum.com/member.php...o&userid=33920 View this thread: http://www.excelforum.com/showthread...hreadid=539113 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there an onload event in Excel?
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 Jim Thomlinson wrote: 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... -- HTH... Jim Thomlinson "loric" wrote: 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 -- loric ------------------------------------------------------------------------ loric's Profile: http://www.excelforum.com/member.php...o&userid=33920 View this thread: http://www.excelforum.com/showthread...hreadid=539113 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
| How to trap delete row event and hide column event? | Excel Programming | |||
| user form-on open event? keydown event? | Excel Programming | |||
| Is there any onLoad kind of function for Excel | Excel Programming | |||
| OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
![loric[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
