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