software

Hi all,

Fairly minor, but niggly point here. I am using Excel 2002, and have
got some control box buttons on a couple of worksheets that run
macros.

Everytime I print, or print preview the worksheet, the button moves
from it's location on the sheet and obscures some of the data. The
button is set such that it is not printed, however, it is annoying me
that it keeps moving!

Any suggestions?

Merry Christmas everyone!

Steve--
stevepain
------------------------------------------------------------------------
stevepain's Profile: www.excelforum.com/member.php...oamp;userid=21759
View this thread: www.excelforum.com/showthread...hreadid=495477See if this helps

support.microsoft.com/d*efault.aspx?kbid=838910
Controls move to the left of the worksheet in Microsoft Excel 2002--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;stevepainquot; gt; wrote
in message ...
gt;
gt; Hi all,
gt;
gt; Fairly minor, but niggly point here. I am using Excel 2002, and have
gt; got some control box buttons on a couple of worksheets that run
gt; macros.
gt;
gt; Everytime I print, or print preview the worksheet, the button moves
gt; from it's location on the sheet and obscures some of the data. The
gt; button is set such that it is not printed, however, it is annoying me
gt; that it keeps moving!
gt;
gt; Any suggestions?
gt;
gt; Merry Christmas everyone!
gt;
gt; Steve
gt;
gt;
gt; --
gt; stevepain
gt; ------------------------------------------------------------------------
gt; stevepain's Profile:
www.excelforum.com/member.php...oamp;userid=21759
gt; View this thread: www.excelforum.com/showthread...hreadid=495477
gt;
Hi Stevepain!

try this:

Right click on the button --gt; Format Control --gt; Properties Tab --gt; and
select the option button quot;Don´t move or size with cellsquot;

this should solve this problem!

or if you don´t need to print the button you can uncheck the checkbox quot;Print
objectquot; at this same way!

i hope this tip can help you!

PEdroquot;stevepainquot; wrote:

gt;
gt; Hi all,
gt;
gt; Fairly minor, but niggly point here. I am using Excel 2002, and have
gt; got some control box buttons on a couple of worksheets that run
gt; macros.
gt;
gt; Everytime I print, or print preview the worksheet, the button moves
gt; from it's location on the sheet and obscures some of the data. The
gt; button is set such that it is not printed, however, it is annoying me
gt; that it keeps moving!
gt;
gt; Any suggestions?
gt;
gt; Merry Christmas everyone!
gt;
gt; Steve
gt;
gt;
gt; --
gt; stevepain
gt; ------------------------------------------------------------------------
gt; stevepain's Profile: www.excelforum.com/member.php...oamp;userid=21759
gt; View this thread: www.excelforum.com/showthread...hreadid=495477
gt;
gt;


Thanks for the input guys.

Pedro - I tried your suggestion, and unfortunately it still appears to
happen.

Bob - unfortunately I cannot get your link to open - can you tell me
how you reached that page,a dn perhaps I can navigate through the
Microsoft support website myself?--
stevepain
------------------------------------------------------------------------
stevepain's Profile: www.excelforum.com/member.php...oamp;userid=21759
View this thread: www.excelforum.com/showthread...hreadid=495477Steve

Try this link. Bob's is missing a couple or three characters.

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).

support.microsoft.com/default...b;en-us;832332

But others have posted that it didn't work for them in all their workbooks.Gord Dibben Excel MVP

On Thu, 22 Dec 2005 10:31:08 -0600, stevepain
gt; wrote:

gt;
gt;Thanks for the input guys.
gt;
gt;Pedro - I tried your suggestion, and unfortunately it still appears to
gt;happen.
gt;
gt;Bob - unfortunately I cannot get your link to open - can you tell me
gt;how you reached that page,a dn perhaps I can navigate through the
gt;Microsoft support website myself?