Syntax

expression.NewWorkbook(Wb)

expression An expression that returns a 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.

Visual Basic for Applications
Private Sub App_NewWorkbook(ByVal Wb As Workbook) Application.Windows.Arrange xlArrangeStyleTiled End Sub
new workbook New Workbook Event NewWorkbook newworkbook event When a new workbook is created?

See also: