共用方式為


Workbook.AddinInstall Event (Excel)

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.

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

請參閱

概念

Workbook Object

Workbook Object Members