Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

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

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Excel 2010 Macro buttons moving and resizing

AcctSolver (TechnicalUser)
2 Aug 11 17:51
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?
SkipVought (Programmer)
2 Aug 11 19:33



Hi,

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.

Skip,

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

Deniall (TechnicalUser)
3 Aug 11 4:44
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.
graham10 (TechnicalUser)
10 Aug 11 11:56
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.     
SkipVought (Programmer)
10 Aug 11 12:02


Post your question in forum707: VBA Visual Basic for Applications (Microsoft): VBA Visual Basic for Applications (Microsoft)

Skip,

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

AcctSolver (TechnicalUser)
22 Aug 11 9:48
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.   

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