I have 3 command buttons (CB's) linked to macros on a spreadsheet. Two
carry out functions, move data, update etc etc. No problem with these.
The third is just a button to "Print Page" and when pressed will do
just that. The problem is that when pressed the other two CB's move
from their position to another part of the spreadsheet. I think the
problem is something to do with the selection of the print range, but
how do I prevent these buttons from moving i.e. "anchor" them in
position. Any help greatly appreciated. Regards John.


--
jo2389hn
------------------------------------------------------------------------
jo2389hn's Profile: http://www.excelforum.com/member.php...o&userid=22269
View this thread: http://www.excelforum.com/showthread...hreadid=388000

xl2002???

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.

jo2389hn wrote:
>
> I have 3 command buttons (CB's) linked to macros on a spreadsheet. Two
> carry out functions, move data, update etc etc. No problem with these.
> The third is just a button to "Print Page" and when pressed will do
> just that. The problem is that when pressed the other two CB's move
> from their position to another part of the spreadsheet. I think the
> problem is something to do with the selection of the print range, but
> how do I prevent these buttons from moving i.e. "anchor" them in
> position. Any help greatly appreciated. Regards John.
>
> --
> jo2389hn
> ------------------------------------------------------------------------
> jo2389hn's Profile: http://www.excelforum.com/member.php...o&userid=22269
> View this thread: http://www.excelforum.com/showthread...hreadid=388000

--

Dave Peterson