Excel 2010 Macro buttons moving and resizing

[AcctSolver]

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]

Hi,

VBA is much better addressed in forum707, 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,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Deniall]

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]

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]

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

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[AcctSolver]

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.