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
--
thank you so much for your help

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





On Apr 27, 2:04 pm, clara wrote:
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
--
thank you so much for your help

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...............
:P
susan


On Apr 27, 2:26 pm, Susan wrote:
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

On Apr 27, 2:04 pm, clara wrote:



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
--
thank you so much for your help- Hide quoted text -

- Show quoted text -

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...b;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...b;en-us;832332

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

clara wrote:

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
--
thank you so much for your help

--

Dave Peterson

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


On Apr 27, 2:59 pm, Dave Peterson wrote:
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...b;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...b;en-us;832332

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

clara wrote:

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
--
thank you so much for your help

--

Dave Peterson