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.
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.
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기