Workbook.AddinInstall Event (Excel)
Occurs when the workbook is installed as an add-in
Syntax
식 .AddinInstall
식 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.
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