Application.WorkbookOpen Event (Excel)
Occurs when a workbook is opened.
Syntax
expression .WorkbookOpen(Wb)
expression A variable that represents an Application object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Wb |
Required |
The workbook. |
Return Value
Nothing
Example
This example arranges all open windows when a workbook is opened.
Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
Application.Windows.Arrange xlArrangeStyleTiled
End Sub