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.