When I press Print or Print Preview, the VBA objects I have placed on a
spreadsheet all move to the left, piling on top of each other. Is there
anyway to prevent this from happening?

http://support.microsoft.com/default...b;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002


http://groups.google.co.uk/groups?lr...apeXSP AM.com


but there was a discussion on this:

DAVE PETERSON:

There's a link on this URL:
http://support.microsoft.com/default.aspx?kbid=838910

How to obtain the hotfix

This issue is fixed in the Excel 2002 post-Service Pack 3 hotfix Hotfix
Package
May 6, 2004. For additional information, click the following article number
to
view the article in the Microsoft Knowledge Base:
829348 Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

That points to this KB article:
http://support.microsoft.com/kb/829348/
Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

That describe how to contact MS to get the link. It's not just a simple
download.

Jim Rech says it is fixed in a security update so the hotfix isn't needed:

Jim Rech:
I think it is, Dave, because it was included in the 10/12/2004 Security
Update. MSKB 873366 describes how to get it. As I recall the fix isn't
mentioned in the doc, it is there; I read it somewhere and proved to my
satisfaction that it worked. I'd be interested to see if you can confirm
this.

see the discussion:
http://groups.google.co.uk/groups?lr...apeXSP AM.com


--
Regards,
Tom Ogilvy

"Frank Hoke" <Frank wrote in message
...
When I press Print or Print Preview, the VBA objects I have placed on a
spreadsheet all move to the left, piling on top of each other. Is there
anyway to prevent this from happening?

See this KB article

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


Also note these follows-up that have previously appeared.

There's a link on this URL:
http://support.microsoft.com/default.aspx?kbid=838910

How to obtain the hotfix

This issue is fixed in the Excel 2002 post-Service Pack 3 hotfix Hotfix
Package
May 6, 2004. For additional information, click the following article number
to
view the article in the Microsoft Knowledge Base:
829348 Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

That points to this KB article:
http://support.microsoft.com/kb/829348/
Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

That describe how to contact MS to get the link. It's not just a simple
download.


--

HTH

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


"Frank Hoke" <Frank wrote in message
...
When I press Print or Print Preview, the VBA objects I have placed on a
spreadsheet all move to the left, piling on top of each other. Is there
anyway to prevent this from happening?

Frank,
My solution to this problem has been to go into design mode, righ
click the object, select format object and under properties set to Mov
and size with cells.
HT

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=39953