Application.NewWorkbook Event (Excel)
Occurs when a new workbook is created.
Syntax
expression .NewWorkbook(Wb)
expression An expression that returns a Application object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Wb |
Required |
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