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