Solved

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

Posted on 2013-12-19
2
367 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel IF statement 4 24
Excel formula that pulls back the id 4 42
Tricky shapes formula part 2 4 21
Copy entire column 6 30
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

730 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