Solved

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

Posted on 2013-12-19
2
359 Views
Last Modified: 2013-12-19
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
0
Comment
Question by:chtullu135
  • 2
2 Comments
 

Accepted Solution

by:
chtullu135 earned 0 total points
ID: 39729614
I found the answer at http://support.microsoft.com/kb/211835
xlFreeFloating is corresponds to Don't move or size with cells
0
 

Author Closing Comment

by:chtullu135
ID: 39729618
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvieā€¦
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

823 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question