VBA & Macro Problems

Fix Excel 2019 ActiveX Controls and VBA Forms on a Second Monitor

Elise WilliamsElise Williams Nov 14, 2026 869 views

Question details

Resolve ActiveX controls or VBA UserForms that fail when an Excel 2019 workbook is opened on a secondary monitor.

Fix Excel 2019 ActiveX Controls and VBA Forms on a Second Monitor
Product
Microsoft Excel 2019
Device & OS
not provided
Scenario
A workbook is opened on a second display after an upgrade from 32-bit Excel 2010 to 64-bit Excel 2019.
Observed behavior
Controls or forms may fail when Excel starts on the secondary display, although they work when Excel starts on the primary display.
Before you start

Check whether the workbook works when Excel starts on the primary monitor, then test it after moving the Excel window to the second monitor. Note the display scaling settings and confirm the installed Excel version under File > Account > About Excel.

Solution 1Recommended

Start Excel on the Primary Monitor and Test Display Scaling

Use this workaround when the controls work after Excel starts on the primary display but fail when it starts on the second display.

1
Open Excel on the primary display

Close Excel, start it on the primary monitor, and open the affected workbook. Test the ActiveX controls or UserForm before moving the window.

2
Move the window

Drag the Excel window to the second monitor and test the same controls or form again. If they work, start Excel on the primary monitor as a temporary workaround.

3
Compare display scaling

On Windows, open Settings > System > Display, select each monitor, and check its Scale setting. Try matching the scaling values temporarily, then restart Excel and retest.

4
Try compatibility display mode

If available, open Excel's File > Options > General and select Optimize for compatibility under User Interface options. Restart Excel and test the workbook on the second monitor.

Start Excel on the Primary Monitor and Test Display Scaling
Temporary window-management option: A third-party window-management utility may help position Excel or its forms, but it does not address an underlying Excel or VBA compatibility issue.
Free Microsoft Office alternative

Work with Excel Files in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easier to move everyday documents between suites. It does not fix Excel's ActiveX or VBA display behavior; check your workbook's control and macro requirements before switching.

Open and edit common Excel formats, including XLSX and XLSUse a familiar spreadsheet interface for everyday workbook tasksMove common Office documents between suites with format supportUse a free, lightweight alternative alongside Excel for files that do not depend on ActiveX controls
microsoft office alternative - wps office

Frequently Asked Questions

Why do the forms work after I move Excel to the second monitor?

The behavior may depend on where Excel starts or on display scaling. Start Excel on the primary monitor, open the workbook, and then drag the window to the second monitor as a workaround.

How can I check whether Excel is 32-bit or 64-bit?

In Excel, select File > Account > About Excel. The window identifies the installed version and whether it is 32-bit or 64-bit.

What if I cannot find any EXD files?

There may be no relevant cached files to remove. Skip that step and test display scaling, Office updates, and 64-bit compatibility instead.

Can display scaling affect Excel forms?

Different scaling values may contribute to display issues. On Windows, check each monitor under Settings > System > Display, try matching the Scale values, and restart Excel before testing.

Will WPS Office fix Excel ActiveX or VBA form errors?

No. WPS Office is an alternative for common spreadsheet tasks, not a repair for Excel's ActiveX or VBA behavior. Verify support for any macros and controls your workbook requires before relying on it.