Workbook.AddinInstall Event (Excel)
Occurs when the workbook is installed as an add-in
expression A variable that represents a Workbook object.
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