Command Button moves on Print

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce Matkovich - 29 Apr 2005 18:19 GMT

I have a sheet and have selected columns A thru O to print. When I print
the selection, the command button I have in column P (outside of the
selection) actually moves to about column C. This happens with File -
Print, the print button, print preview, and with vb code to print.

I am using Excel XP with Windows XP.

Any ideas what could be causing this?

Bruce

Reply to this Message

Gord Dibben - 29 Apr 2005 20:07 GMT

Bruce

http://support.microsoft.com/default.aspx?scid=kb;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.aspx?scid=kb;en-us;832332

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

Gord Dibben Excel MVP

>I have a sheet and have selected columns A thru O to print. When I print
>the selection, the command button I have in column P (outside of the
[quoted text clipped - 6 lines]
>
>Bruce

Reply to this Message

Bruce Matkovich - 29 Apr 2005 21:16 GMT

Thanks Gord, your information fixed my problem. I just updated Office XP
this morning and it still had problems. But after following the advice in
the Microsoft Support article, I was able to work around it.

Bruce

> Bruce
>
[quoted text clipped - 28 lines]
>>
>>Bruce

Reply to this Message

Gord Dibben - 29 Apr 2005 21:40 GMT

Glad to hear.

Thanks for the feedback.

Gord

>Thanks Gord, your information fixed my problem. I just updated Office XP
>this morning and it still had problems. But after following the advice in
[quoted text clipped - 34 lines]
>>>
>>>Bruce

Reply to this Message