VBA & Macro Problems

Fix an Excel ActiveX Button That Fails on a Secondary Monitor

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

Get an Excel ActiveX button working on a secondary monitor when the displays use different scaling settings.

Fix an Excel ActiveX Button That Fails on a Secondary Monitor
Product
Microsoft Excel
Device & OS
Windows
Scenario
An Excel workbook with an ActiveX button is used across two monitors with different Windows scaling settings.
Observed behavior
The button works on the primary monitor but may not respond on the secondary monitor.
Before you start

Connect both monitors and check their current scaling values in Windows Settings > System > Display. Save any open work before signing out of Windows.

Solution 1Recommended

Match the Windows scaling settings on both monitors

Use this approach when the ActiveX button fails on a secondary display with a different scaling value.

1
Check the primary monitor

Open Settings > System > Display, select the primary monitor, and note its Scale setting.

2
Match the secondary monitor

Select the secondary monitor in the display diagram and set Scale to the same value as the primary monitor. For example, choose 200% if the primary monitor is set to 200%.

3
Sign out and test

Save your work, select Start > your account icon > Sign out, and then sign in again. Open the workbook in Excel and test the button on the secondary monitor.

4
Check whether the issue persists

If the button still fails, check the Excel version under File > Account > About Excel. Test the button on each monitor and, if available, test another workbook with an ActiveX button to see whether the issue is limited to one file.

Match the Windows scaling settings on both monitors
Scaling changes the display size: Matching the scaling settings can change the apparent size of text and apps on the secondary monitor.
Free Microsoft Office alternative

Work with Excel-Compatible Spreadsheets in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move everyday spreadsheet work between applications. It does not fix Excel's ActiveX display issue, and ActiveX controls and VBA macros may not work the same way in WPS.

Open and edit Excel-compatible XLSX and XLS spreadsheets.Use a familiar spreadsheet interface for everyday workbook tasks.Move common Office documents between applications with format compatibility.Use a free, lightweight alternative for spreadsheet work that does not depend on Excel ActiveX controls.
microsoft office alternative - wps office

Frequently Asked Questions

Do both monitors have to be set to 200% scaling?

No. In Settings > System > Display, set the secondary monitor to the same scaling value as the primary monitor. Use 200% only if that is the primary monitor's setting.

Why should I sign out after changing display scaling?

Signing out and back in allows Windows and applications to start a new session with the updated display settings. Save your work before selecting Start > your account icon > Sign out.

What should I check if matching the scaling does not help?

In Excel, check File > Account > About Excel for the version. Test the button on both monitors and test another workbook with an ActiveX button, if available, to determine whether the issue is limited to one workbook.

Will WPS Office fix the Excel ActiveX button?

No. WPS Office is an alternative for compatible spreadsheet work, not a fix for Excel's ActiveX display behavior. ActiveX controls and VBA macros may not work the same way in WPS.