Office Settings & Configuration

Fix Excel Button and UserForm Layout Differences Across Screens

Kushani NimanthikaKushani Nimanthika Nov 18, 2026 870 views

Question details

The user needs Excel worksheet buttons and VBA UserForms to display consistently across computers with different screen settings.

Fix Excel Button and UserForm Layout Differences Across Screens
Product
Microsoft Excel
Device & OS
not provided
Scenario
An Excel workbook with buttons and VBA UserForms is used on computers with different display and software configurations.
Observed behavior
Buttons and form controls can shift, and text may appear oversized on some screens.
Before you start

Compare the affected computers' display scaling, screen resolution, Excel version, and installed fonts. Note the worksheet zoom level and which buttons or UserForms display differently.

Solution 1Recommended

Compare display settings and set button properties

Use this approach to identify configuration differences and make worksheet button dimensions and placement more predictable.

1
Compare display settings

On each Windows computer, open Settings > System > Display and check Scale and Display resolution. Test with matching settings where practical, then reopen Excel.

2
Check Excel and fonts

In Excel, open File > Account to compare Office versions. Select the affected button and check its font and size; confirm that the same font is installed on each computer.

3
Set button size and placement

Right-click a worksheet button and open Format Control or Size and Properties, depending on its type. Set its height and width, then review the placement options, such as whether it moves or sizes with cells.

4
Check ActiveX controls

For an ActiveX button, select Developer > Design Mode, right-click the button, and choose Properties. Review its dimensions, font, and placement settings, then turn off Design Mode.

5
Test worksheet zoom

Use the zoom control at the bottom of Excel to compare the worksheet at the same zoom percentage on each computer. Recheck the layout under the display settings users normally use.

Compare display settings and set button properties
Controls may scale differently: Matching settings can help isolate the cause, but Excel and Windows scaling may still produce different results across configurations.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its support for common Excel formats can make moving everyday workbook work straightforward, although it does not fix Microsoft Excel's VBA UserForm scaling behavior.

Open and edit common Microsoft Excel formats, including XLSXUse a familiar spreadsheet interface for everyday workbook tasksWork with worksheet layouts and formatting in a lightweight office suiteMove everyday spreadsheet work to a free Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel UserForm look different on another computer?

Display scaling, resolution, installed fonts, and Office versions can affect how a UserForm renders. Compare those settings on both computers and test the form under the configurations users actually use.

Where can I check display scaling in Windows?

Open Settings > System > Display and look for Scale and Display resolution. After changing a setting for testing, reopen Excel and check the workbook again.

How do I stop a worksheet button from moving with cells?

Right-click the button and open Format Control or Size and Properties. Under its placement or properties options, choose the setting that keeps it from moving or sizing with cells, if available for that control type.

Will changing worksheet zoom fix a VBA UserForm?

Worksheet zoom affects the worksheet view, not necessarily the VBA UserForm. Check UserForm control properties in Developer > Visual Basic and test the form separately.

Can WPS Office fix Excel VBA UserForm scaling?

No. WPS Office is an alternative for working with spreadsheets, not a fix for Excel's UserForm scaling. Test any workbook that depends on VBA macros or UserForms before relying on it in another application.