VBA & Macro Problems

Why Excel Macros Do Not Record Third-Party Add-In Actions

WPS Content Manager Sep 28, 2026 869 views

Question details

The user is attempting to record a VBA macro that includes actions performed within a third-party Excel add-in, but the macro recorder fails to generate any code for those specific actions.

Why Excel Macros Do Not Record Add-In Actions

Product: Microsoft Excel
Device & OS: not provided
Scenario: Recording VBA macros to automate repetitive spreadsheet tasks that rely on third-party add-ins like Ablebits.
Observed behavior: Excel's native macro recorder successfully captures standard spreadsheet interactions but completely ignores clicks and commands executed inside the third-party add-in.

Before you start

Verify the documentation of the specific Excel add-in you are using to see if the developer has provided a public API or built-in VBA support.

Solution 1Recommended

Call Add-In Functions Directly via VBA References

Since the macro recorder cannot capture add-in clicks, you must check if the add-in exposes a VBA interface and call its functions directly in your code.

Excel's macro recorder is designed to translate built-in ribbon commands and cell interactions into VBA code. It cannot monitor or interpret custom forms and routines compiled inside third-party add-ins.

To automate an add-in, the developer must explicitly expose public VBA routines. If they have done so, you can manually write the code to trigger those functions.

Open the VBA Editor

Press 'Alt + F11' on your keyboard while in Excel to open the Visual Basic for Applications window.

Check available references

Click on 'Tools' in the top menu bar, then select 'References'. Scroll through the list to find the name of your specific add-in.

Enable the add-in reference

If your add-in is listed, check the box next to it and click 'OK'. You can now use the Object Browser (F2) to view its available classes and write code to call its functions manually.

Call Add-In Functions Directly via VBA References

Native Microsoft Add-Ins: Some Microsoft-built add-ins, such as Solver, are specifically designed to support macro recording. If you are using Solver, ensure the Solver add-in is enabled in Excel Options.

Solution 2

Contact the Add-in Developer for Support

If the add-in does not expose public routines, you will need to request an automation method directly from the creator.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

While VBA macro limitations with third-party add-ins are an inherent restriction in Microsoft Excel, WPS Office provides a robust, lightweight, and highly compatible alternative for your daily spreadsheet processing. It offers built-in advanced data analysis tools, reducing your dependency on external add-ins.

1. Download and Install: Visit the official WPS website to download WPS Office for free and complete the quick installation process.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing Excel workbooks without losing formatting or data.
3. Utilize Built-in Tools: Explore the comprehensive 'Data' and 'Formulas' tabs to perform advanced calculations natively without needing external add-ins.

Free and lightweight office suite with rapid startup timesExcellent compatibility with Microsoft Excel formats (.xlsx, .xls, .xlsm, .csv)Built-in advanced formulas and data processing featuresFamiliar user interface requiring no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I use SendKeys to automate add-in actions in Excel?

Yes, as a workaround, you can use the VBA Application.SendKeys method to simulate keystrokes that navigate the add-in menu. However, this method is highly unreliable and can execute actions on the wrong application if Excel loses focus.

Are there any add-ins that work perfectly with the macro recorder?

Yes, native Microsoft add-ins like the Solver Add-in and Analysis ToolPak are specifically programmed to integrate with the Excel macro recorder, allowing your clicks to be automatically translated into VBA code.

Why did my macro record perfectly before installing the add-in?

The macro recorder maps native Excel ribbon commands to VBA syntax. Custom user forms, specialized menus, or external code run by a third-party add-in operate outside of this native mapping environment.

Excel & Data Problems