Graphical objects moved & resized when opening file w/ Excel 2007

[JimV]

Periodically, macro buttons and other shapes that are on a sheet will undergo
a vast size change (e.g., object and the text inside both grow by a factor of
maybe three) and move to a new place on the sheet. This never occurs while
in the sheet, whenever it occurs, it's always upon re-opening the file after
a previous save. There are no changes in number or sizes of the rows or
columns in this sheet. This was never a problem in Excel 2003.

 

[Shane Devenshire]

Hi,

Although this may not help select the objects and then right-click them and
choose Size and Properties, Properties, Don't move or size with cells.

 

[JimV]

I will give this a try. Since it happens only once in a while, it'll take
some time to confirm whether or not this helps. I am doubtful, though, since
the numbers and sizes of the rows and columns have not changed.

 

[Simon Murphy]

Jim
Are these ActiveX controls or the Forms ones?
I'm guessing they are the activex ones which have never been
fantastically stable. Especially if the sheet is zoomed to anything
other than 100%.

If its a big problem I recommend you replace them with the native Excel
forms controls.

(have seen this issue loads in Excel 2007, and earlier)

Cheers
Simon
Excel development website: www.codematic.net

 

[JimV]

They were simply Excel drawing shapes (e.g., rectangle, text box). Some had
a macro assigned to it, but not all did. The shapes would move/resize
regardless of whether they had a macro assigned.

Thanks.