• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

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

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
  • 2
1 Solution
chtullu135Author Commented:
I found the answer at http://support.microsoft.com/kb/211835
xlFreeFloating is corresponds to Don't move or size with cells
chtullu135Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now