Excel.Application.WorkbookOpen.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.WorkbookOpen event (Excel)	vbaxl10.chm504081	vbaxl10.chm504081	Excel.Application.WorkbookOpen	37a5b55d-7968-29a2-3f87-edc3334c8ced	04/05/2019	medium

Application.WorkbookOpen event (Excel)

Occurs when a workbook is opened.

Syntax

expression.WorkbookOpen (Wb)

expression A variable that represents an Application 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

[!includeSupport and feedback]