Workbook.IsAddin property (Excel)

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

Syntax

expression.IsAddin

expression A variable that represents a Workbook object.

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.

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