Open Event

Microsoft Excel Visual Basic

previous page next page

Open Event

       

Occurs when the workbook is opened.

Private Sub Workbook_Open()

Example

This example maximizes Microsoft Excel whenever the workbook is opened.

Private Sub Workbook_Open()
    Application.WindowState = xlMaximized
End Sub
previous page start next page