title: How to stop ActiveX objects automatically changing size in office?
body: <p><a href="http://social.msdn.microsoft.com/Forums/office/en-US/61d26275-3b23-4d58-87a7-f6412c51501e/command-buttons-resizing-themselves-without-changing-size-of-cells-around?forum=exceldev" rel="noreferrer">This thread</a> discusses a problem I've been having with ActiveX objects in an Excel spreadsheet. It's a mess to read through and ultimately doesn't have a cohesive answer.</p>
  
  <p>The problem is 100% reproduceable:</p>
  
  <ol>
  <li>Open workbook with ActiveX objects in spreadsheet while using a docking station </li>
  <li>Disconnect machine from docking station, triggering a resolution change (there are other causes too, mine is with a docking station, it seems changing resolution causes this)</li>
  <li>Click an ActiveX control - they immediately resize and the font changes size. The fontsize change is NOT a function of the <code>.Font.Size</code> parameter but something which cannot be changed after the problem occurs, other than continually increasing the fontsize</li>
  </ol>
  
  <p>The only seemingly authoritative solution involves a MS patch (it was a "hotfix" several years ago, though, so it doesn't seem practical for full deployment) and registry edits, which is not practical for my use case.</p>
  
  <p>I am looking for a way to either:</p>
  
  <ol>
  <li>Prevent this change from occuring</li>
  <li>Find the best work around</li>
  </ol>
  
  <p>There is a lack of authoritative information on this problem online. I am intending to post my work around, however, it is not even close to ideal and I would much prefer a better solution.</p>