Workbook.IsAddin Property

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 clicking 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

See also:

• Workbook Object
• Workbook Object Members