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


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 http://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 
 http://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 http://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
http://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 (6)

  1. NormW says:

    I am experiencing this same problem in Excel 2013.  Is there a workaround/hotfix for this issue in Excel 2013?

  2. JORGE CASTILLO says:

    *** office and your activex controls. Jorge CASTILLO

  3. Bodynose says:

    I am experiencing this same problem in Excel 2013. Is there a workaround/hotfix for this issue in Excel 2013?

  4. PIPEtalk says:

    Can this solution be used for Excel 2013. Many of us are experiencing the issue.

  5. Erika says:

    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?

  6. MQ says:

    I have been developing Excel 2010 tools company wide and the IT Support team has been applying the MS Hot Fix at regular intervals. It seems that even once applied, it has to be applied again after some Windows Updates taking place!
    I have been so fed up with the ActiveX button that I have switch all of them to normal user Form buttons with the macro assigned.

    Now they don’t move and everybody is happy… especially the IT Support department!
    I can’t understand why Microsoft is not fixing their own applications!