Workbook.IsAddin property (Excel)

  • Article

True if the workbook is running as an add-in. Read/write Boolean.

Syntax

expression.IsAddin

expression A variable that represents a Workbook object.

Remarks

When you set this property to True, the workbook has the following characteristics:

  • You won't be prompted to save the workbook if changes are made while the workbook is open.

  • The workbook window won't be visible.

  • Any macros in the workbook won't be visible in the Macro dialog box (displayed by pointing to Macro on the Tools menu and choosing Macros).

  • Macros in the workbook can still be run from the Macro dialog box even though they're not visible. In addition, macro names don't need to be qualified with the workbook name.

  • Holding down the Shift key when you open the workbook has no effect.

Example

This example runs a section of code if the workbook is an add-in.

If ThisWorkbook.IsAddin Then 
 ' this code runs when the workbook is an add-in 
End If

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.