Excel 2010 - ActiveX controls resize or shift during or after print preview

Here's an interesting scenario. You have an Excel 2010 spreadsheet that contains multiple activeX controls. After you do a print preview of the spreadsheet and save the sheet, close it and re-open it you notice that some or all of the ActiveX controls are resized. They have either gotten smaller or larger, or have shifted left or right.

The fix for this problem is a two-part fix.

First, click on over to https://support.microsoft.com/kb/2596494 and click the hotfix link to request the hotfix package. Once you have the hotfix, install it.

After the hotfix is installed, you need to go into the registry and make an addition. From https://support.microsoft.com/kb/2596575:

1. Click Start, click Run, type regedit in the Open box, and then click OK.
2. Locate and then click the following registry subkey:

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

3.On the Edit menu, point to New, and then click DWORD (32-bit) value.
4.Type MultiSheetLegacyPrint, and then press ENTER.
5. In the Details pane, right-click MultiSheetLegacyPrint, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7.Exit Registry Editor.