VBA & Macro Problems

Fix an Inactive Excel COM Add-In Created by a Signed XLL

Phi Hung VoPhi Hung Vo Nov 13, 2026 869 views

Question details

The user needs to activate a dynamically created Excel COM add-in that remains inactive even though its parent XLL is signed and stored in a trusted location.

Fix an Inactive Excel COM Add-In Created by a Signed XLL
Product
Microsoft Excel
Device & OS
not provided
Scenario
A signed XLL creates a COM add-in for custom Excel functions.
Observed behavior
The dynamically created COM add-in remains inactive and Excel reports that macros were disabled.
Before you start

Confirm that the XLL is signed and identify the COM add-in it creates. Ask your IT administrator whether your organization requires application add-ins to be signed by a trusted publisher.

Solution 1Recommended

Verify the Generated Add-In’s Signature and Publisher

Use this approach when Excel requires application add-ins to be signed by a trusted publisher.

The XLL’s signature does not automatically sign a separate add-in that it creates. A trusted file location also does not necessarily satisfy Excel’s trusted-publisher requirement for that add-in.

1
Inspect the inactive add-in

In Excel, open File > Options > Add-ins. Select COM Add-ins in the Manage list, click Go, and identify the dynamically created add-in.

2
Check the security requirement

Open File > Options > Trust Center > Trust Center Settings > Add-ins and check whether “Require Application Add-ins to be signed by Trusted Publisher” is enabled.

3
Verify the generated add-in

Ask the add-in developer to identify the generated add-in’s executable component and verify whether it has a valid digital signature. If it has no physical file, ask the developer how the component is registered and how Excel’s signing requirement applies.

4
Sign and trust the publisher

Have the developer sign the applicable add-in component, then work with your administrator to trust its publisher according to your organization’s policy. Reinstall or reload the add-in and restart Excel.

Verify the Generated Add-In’s Signature and Publisher
The XLL and generated add-in are separate: Trusting the XLL’s publisher or location does not by itself prove that the dynamically created add-in is signed.
Free Microsoft Office alternative

Work With Excel Files in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move everyday workbook tasks. It does not fix Excel’s add-in security settings.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday workbook tasksMove compatible workbooks between Office suitesUse a free, lightweight alternative to Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why is the COM add-in inactive if the XLL is signed?

The dynamically created add-in may be a separate component without its own signature. If Excel requires application add-ins to be signed by a trusted publisher, the XLL’s signature may not satisfy that requirement.

Where can I check Excel’s add-in signing requirement?

Open File > Options > Trust Center > Trust Center Settings > Add-ins and look for “Require Application Add-ins to be signed by Trusted Publisher.” Your organization may control this setting.

Does a trusted location automatically trust a generated COM add-in?

No. A trusted location for the XLL does not automatically give a separate generated add-in a digital signature or satisfy the trusted-publisher requirement.

What if the generated add-in has no visible file location?

Ask the developer how the add-in is created and registered, and which component Excel checks. The developer can determine whether signing is applicable and how to meet the organization’s security requirements.