Application.WorkbookOpen Event (Excel)

Occurs when a workbook is opened.

Syntax

expression. WorkbookOpen( _Wb_ )

expression A variable that represents an [Application](Excel.Application(Graph property).md) object.

Parameters

Name Required/Optional Data type Description
Wb Required Workbook The workbook.

Return value

Nothing

Example

This example arranges all open windows when a workbook is opened.

Private Sub App_WorkbookOpen(ByVal Wb As Workbook) 
 Application.Windows.Arrange xlArrangeStyleTiled 
End Sub

See also

Application Object