Export (0) Print
Expand All

Application.NewWorkbook Event (Excel)

Occurs when a new workbook is created.

expression .NewWorkbook(Wb)

expression An expression that returns a Application object.

Parameters

Name

Required/Optional

Data Type

Description

Wb

Required

Workbook

The new workbook.

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
Show:
© 2015 Microsoft