A button Control

[Guest]

Hi all,

There is a button control on a worksheet, but when its position often
changes when the workbbook is opened.Could you tell me how to fix it.


Clara

 

[Susan]

right click on the button & choose "format control". (if this option
does not come up, then it's a control toolbox button, not a form
button. in that case you would have to choose "properties".)

in format control, choose the "properties" tab, select the button that
says "don't move or size with cells", & see if that helps.
this way when you add rows or columns or move things around, the
button stays exactly where it is.

actually, in the "properties" section for a control toolbox button, i
don't see where/how you can anchor it like that...........

i hope it's a forms button.

susan

 

[Susan]

duh.

there isn't anything in the properties section, but if you don't
choose properties but instead continue down the list & choose "format
control", then it has the same thing as a forms button.

i try...............

susan

 

[Dave Peterson]

I've never seen the buttons move when the workbook is opened.

There was a bug in xl2002 (and xl2003, IIRC) that may have moved some controls
after a print or a print preview, though.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

But Jim Rech recently posted this:
This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directly
mention this fix, it's in there).

http://support.microsoft.com/default.aspx?scid=kb;en-us;832332

But Myrna Larson (and others) posted that it didn't work for her in all her
workbooks.

 

[Susan]

maybe she has some kind of an auto_open macro that inserts rows or
columns (or deletes them) or something.......
that's the only thing i know of that makes them "move".
susan