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 <c...@discussions.microsoft.com> 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 <bogenex...@aol.com> 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 <c...@discussions.microsoft.com> 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 <peter...@verizonXSPAM.net> 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