Export (0) Print
Expand All

Workbook.AddinInstall Event

Office 2007
Occurs when the workbook is installed as an add-in

Syntax

expression.AddinInstall

expression   A variable that represents a Workbook object.

Return Value
Nothing

Example

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

Visual Basic for Applications
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



Community Additions

ADD
Show:
© 2014 Microsoft