<div>
I found the answer at <a href="http://support.microsoft.com/kb/211835" rel="ugc nofollow">http://support.microsoft.com/kb/211835</a>
</div>


I found the answer at http://support.microsoft.com/kb/211835 [http://support.microsoft.com/kb/211835]

<div>
<div class="content wysiwyg-content">
I am trying to set the format controls of several activex command buttons on an excel sheet to &quot;Don't Move or size with cell&quot; using vba. &nbsp;I've looked into the placement property but do not see that option. &nbsp;Below are the only three options I found<br />
<br />
ws.Shapes(&quot;cmdDeleteLine&quot;)<wbr />.Placement<wbr /> = xlMove<br />
ws.Shapes(&quot;cmdDeleteLine&quot;)<wbr />.Placement<wbr /> = xlMoveAndResize<br />
ws.Shapes(&quot;cmdDeleteLine&quot;)<wbr />.Placement<wbr /> = xlFreeFloating
</div>
</div>


I am trying to set the format controls of several activex command buttons on an excel sheet to "Don't Move or size with cell" using vba.  I've looked into the placement property but do not see that option.  Below are the only three options I found

ws.Shapes("cmdDeleteLine").Placement = xlMove
ws.Shapes("cmdDeleteLine").Placement = xlMoveAndResize
ws.Shapes("cmdDeleteLine").Placement = xlFreeFloating

Trying to set ActiveX Control formating to Don't move and resize with cells

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.