Objects On Sheet Shift after Print

[Cory Blythe]

I have an Excel spread sheet with a button and 3 text boxes which are filled
from a query against a database when the user clicks the button. Everything
works flawlessly until you print the sheet.

After printing the first copy, the Button and 3 textboxes are all left
justified on the sheet. If you select 4 copies the first comes out fine the
next 3 print with the buttons and text boxes left justified.

I have a second sheet that does exactly the same thing and prints fine. Can
anyone tell me what I set or didn't set on this first sheet that is causing
the behaviour, I have tried to compare the 2 but too no avail.

Thanks

 

[Bob Phillips]

Check out this article

http://support.microsoft.com/d­efault.aspx?kbid=838910
Controls move to the left of the worksheet in Microsoft Excel 2002

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Cory Blythe]

Wow thanks a ton that did it. I really did try finding the answer but
apparently I didn't use the right combo of search words.

Thanks Again

 

[Bob Phillips]

It's a known problem from the regular spooks here

Bob