Workbook.Open Event

  • Article
Excel Developer Reference

Occurs when the workbook is opened.

Syntax

expression.Open

expression   An expression that returns a Workbook object.

Example

This example maximizes Microsoft Excel whenever the workbook is opened.

Visual Basic for Applications 
  Private Sub Workbook_Open()
    Application.WindowState = xlMaximized
End Sub

See Also