Share via

ActiveX and form controls resize themselves when clicked or doing a print preview

  • Article

When using ActiveX controls in Microsoft Excel 2010 you may find the controls are resizing themselves when performing various tasks. Say what??? The controls can grow in size or become smaller. Below is a step by step on how to fix the problem:

1. Install the hotfix from https://support.microsoft.com/kb/2598144.

2. Next, you need to enable the hotfix through a registry key that matches your problem description. In the articles below, pick the symptom that matches yours and then click to navigate to the KB Article. Then click the "FixIt" button on the article web page to automatically add the registry keys needed. However, if you prefer to edit the registry manually, you can do so.

An ActiveX button changes to the incorrect size after you click it in an Excel 2010 worksheet 
 https://support.microsoft.com/kb/2598259

To edit the registry manually for this fix, do the following:

  • Click Start, click Run, type regedit in the Open box, and then click OK.

  • Locate and then select the following registry subkey:

    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

  • On the Edit menu, point to New, and then click DWORD (32-bit) value.

  • Type LegacyAnchorResize, and then press Enter.

  • In the Details pane, right-click LegacyAnchorResize, and then click Modify.

  • In the Value data box, type 1, and then click OK.

  • Exit Registry Editor.

A button form control is displayed incorrectly in a workbook after you view the print preview of the workbook in Excel 2010 https://support.microsoft.com/kb/2598310

To edit the registry manually for this fix, do the following:

  • Click Start, click Run, type regedit in the Open box, and then click OK.

  • Locate and then select the following registry subkey:

    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

  • On the Edit menu, point to New, and then click DWORD (32-bit) value.

  • Type MultiSheetPrint, and then press Enter.

  • In the Details pane, right-click MultiSheetPrint, and then click Modify.

  • In the Value data box, type 1, and then click OK.

  • Select the following registry subkey again:

    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

  • On the Edit menu, point to New, and then click DWORD (32-bit) value.

  • Type LegacyAnchorResize, and then press Enter.

  • In the Details pane, right-click LegacyAnchorResize, and then click Modify.

  • In the Value data box, type 1, and then click OK.

  • Exit Registry Editor.

An ActiveX button is changed to an incorrect size in an Excel 2010 worksheet after you view the print preview of the worksheet
https://support.microsoft.com/kb/2598260

To edit the registry manually for this fix, do the following:

  • Click Start, click Run, type regedit in the Open box, and then click OK.

  • Locate and then select the following registry subkey:

    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

  • On the Edit menu, point to New, and then click DWORD (32-bit) value.

  • Type LegacyAnchorResize, and then press Enter.

  • In the Details pane, right-click LegacyAnchorResize, and then click Modify.

  • In the Value data box, type 1, and then click OK.

  • Exit Registry Editor.

Comments

  • Anonymous
    October 01, 2013
    I am experiencing this same problem in Excel 2013.  Is there a workaround/hotfix for this issue in Excel 2013?

  • Anonymous
    March 04, 2014
    *** office and your activex controls. Jorge CASTILLO

  • Anonymous
    March 19, 2014
    I am experiencing this same problem in Excel 2013. Is there a workaround/hotfix for this issue in Excel 2013?

  • Anonymous
    March 24, 2014
    Can this solution be used for Excel 2013. Many of us are experiencing the issue.

  • Anonymous
    April 28, 2014
    Hi, I'm experiencing this issue, but the buttons I have tend to resize after the user scroll right and back to the left. I have applied the hotfix and followed all the steps, but now has even worsen the problem, the buttons not only resize and move but leave a shadow in grey on it's original position. Any suggestions?

  • Anonymous
    August 19, 2014
    The comment has been removed

    • Anonymous
      March 22, 2017
      Can you tell me how to do this?My barcodes move and resize randomly on the tabs. Is this the same issue you solved?Thanks

  • Anonymous
    June 10, 2016
    The comment has been removed

  • Anonymous
    July 27, 2016
    THANK YOU! Spent ages trying all sorts of other fixes

  • Anonymous
    November 16, 2016
    Thank you this fix the problem