Combo and check boxes move left after printing

[Heidi]

I am using XP, Excel 2002. I am using a spreadsheet not
designed by me that contains macros, drop boxes and check
boxes. When I either print or print preview, the drop
boxes all shift left and overlap the other cells. If I
save and close, they stay that way and can't be moved. If
I print and close without saving, they go back where they
were.

There are two of us in the office that are having this
problem, no one else seems to. I don't recall having this
problem before switching to a new PC with XP, the other
user is on Windows 2000.

Any help appreciated.

 

[Ken Wright]

This problem occurs after you install Microsoft Office 2002 Service Pack 3
(SP3). This problem does not occur in Office 2002 versions that are earlier than
SP3. For a fix see the following Microsoft article.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910

 

[Guest]

Thank you so much -I see there's a "hotfix" for it dated
May 13, 2004, but I can't seem to find a link for it. Can
you possibly point me in the right direction?

 

[Myrna Larson]

The fix is to change the setting from the default of "move but don't size with
cells" to "move and size with cells". For a control from the Forms toolbox,
you do that via the Format/Object. For a control from the control tool box,
get into design mode, select the object(s). At that point you can go to the
Format menu, as above, or you can show the properties window and change the
setting for Placement to 1.

 

[Debra Dalgleish]

You can contact Microsoft Product Support Services to obtain the hotfix:

http://support.microsoft.com/default.aspx?kbid=829348#4