Share via

AddinInstall Event [Excel 2003 VBA Language Reference]

  • Article

Occurs when the workbook is installed as an add-in

Private Sub Workbook_AddinInstall()

Example

This example adds a control to the standard toolbar when the workbook is installed as an add-in.

Private Sub Workbook_AddinInstall()
    With Application.Commandbars("Standard").Controls.Add
        .Caption = "The AddIn's menu item"
        .OnAction = "'ThisAddin.xls'!Amacro"
    End With End Sub
End Sub

Applies to | Workbook Object

See Also | AddinUninstall Event | WorkbookAddinInstall Event | WorkbookAddinUninstall Event