object movement

[Frank Hoke]

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?

[Casey]

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

[Tom Ogilvy]

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...scapeXSPAM.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...scapeXSPAM.com


--
Regards,
Tom Ogilvy

"Frank Hoke" <Frank [email protected]> wrote in message
news:[email protected]...
> 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?

[Bob Phillips]

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 [email protected]> wrote in message
news:[email protected]...
> 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?