I am struggling with excel command buttons that move around my
worksheet when rows and columns are hidden. I need for them to move
with the cell and resize, as I need them to be hidden at certain
times. My program is used to keep scores in the fall season and I am
1/3 through the season.

Is there a way that I can write a macro to place (or actually in this
case replace) the rogue command buttons back in their intended
specific location and reset the size, if necessary to its original
size? This would solve my problem quickly, but I do not know if it is
possible to write such a macro.

I have experimented with the macro writer, but it seems to want to
relocate by scaling from where the button is. Since I do not know
where the darn button is, that does not work for me.

As an example, I would need a macro to do the following...

1) Locate the existing command button (Button 1) in cell E26 so the
left edge and top of the button are at the cell left edge and top of
the cell (the button has moved to the top edge of the page)
2) Make the command button (Button 1) 1" wide and .25" high (not sure
if I need to do this or not, because I am not sure if the command
button stayed the same size when it moved - I will have to trial and
error to find out when I figure out how to move the button).

I would really appreciate some help. I am self-taught and I am
partially blind. My users are unskilled moms using the program every
week, and on some oftheir computers the buttons move, and on others
they do not. (talk about the blind leading the blind :-) - just
kidding).

I suspect it is an available memory issue, but am unsure, as older
computers and netbooks seem to have the problem...

I need a quick fix, and could place a similar macro in front of the
call for each button (There are close to 100 buttons on the sheet -
only a couple are supposed to appear at a time).

Is this possible? Thank you.