Excel.Application.NewWorkbook(even).md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.NewWorkbook event (Excel)	vbaxl10.chm504073	vbaxl10.chm504073	Excel.Application.NewWorkbook	a3c29269-af09-08da-f0c3-82e192aa896f	04/05/2019	medium

Application.NewWorkbook event (Excel)

Occurs when a new workbook is created.

Syntax

expression.NewWorkbook (Wb)

expression An expression that returns an Application object.

Parameters

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

Example

This example arranges open windows when a new workbook is created.

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

[!includeSupport and feedback]