Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Excel 2010 Macro buttons moving and resizing

Excel 2010 Macro buttons moving and resizing

Excel 2010 Macro buttons moving and resizing

We have had 35 macros in a particular Excel spreadsheet for many years; well prior to Excel 2003.  Each macro is on top of one of 35 different data columns.  We upgraded to Windows 7 and Excel 2010 a few months back.  Now when we press the macro keys, they begin to resize and move. It appears that they are no longer appropriately anchored.  They do still return the proper data, but even seeing which one to push has become difficult.  Why did this happen and how do I fix it?

RE: Excel 2010 Macro buttons moving and resizing


VBA is much better addressed in forum707: VBA Visual Basic for Applications (Microsoft), than in this forum.

What kind of controls? ActiveX, Forms?

In design mode, right-click a control and look at the PROPERTIES tab.  Don't move ... ought to be the selected option.


glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Excel 2010 Macro buttons moving and resizing

I have experienced what sounds like the identical problem.  I have one particular spreadsheet:  quite large and complex, about a dozen worksheets, lots of CommandButtons.  The spreadsheet has been running fine for several years, under XL2003.

A few months ago I upgraded to XL2010, and since then I have had the behaviour you describe.  It only happens with one particular CommandButton, and it only happens occasionally.  I cannot discern any pattern wrt when it will happen and when it will not happen.  When it does happen, it is in response to the activation of that button, not any other button.  The moving is always upwards and to the left, but the amounts of the move vary.  The resizing is always a shrinking, of both the box size and the text size.  It survives being saved (and Excel being closed) then re-opened in a new Excel session.  I have not explored whether having moved once it will move again later, because I always have to fix the problem up immediately after it happens.

It was driving me batty.  In desperation I added a few lines of VBA into the WorksheetOpen event handler to put the button back where I need it to be.  I'd love to know what is going on.

RE: Excel 2010 Macro buttons moving and resizing

I am having the exact same issue.  Any updates on a fix?  I heard this is a known issue with MS?  It only affects users with Excel 2010.     

RE: Excel 2010 Macro buttons moving and resizing

I followed Skip's suggestion in #1 and made sure anything that did not say "don't move" said so.  That mostly fixed the problem.  When the macros are run, the buttons still move according to my user.  But when she reopens the document, they are where they need to be. Works for us.   

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close